January 16, 2013 at 1:26 am
hi there,
We currently have an issue where on one of our SQL Servers, there is a high number of SQL Compilations\sec. There was no new code promoted to the database.
Does anyone perhaps know what we should do to investigate what the cause was for these compilations or any other way we can check why these compilations are happening on the server?
Regards
IC
January 16, 2013 at 2:23 am
Have you tried looking at the Activity Moniter? I'm sort of assuming you can see this activity going on , so the Activity Moniter may help identify the process.
January 22, 2013 at 12:40 am
Imke Cronje (1/16/2013)
We currently have an issue where on one of our SQL Servers, there is a high number of SQL Compilations\sec. There was no new code promoted to the database.
There could be many reasons for this. like memory issues , tempdb issues . see the link http://www.mssqltips.com/sqlservertip/2316/how-to-identify-sql-server-cpu-bottlenecks/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply