Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

High Volume of SQL Compilations/sec Expand / Collapse
Author
Message
Posted Wednesday, January 16, 2013 1:26 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 3:17 AM
Points: 254, Visits: 633
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
Post #1407665
Posted Wednesday, January 16, 2013 2:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 2:41 PM
Points: 23, Visits: 66
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.
Post #1407694
Posted Tuesday, January 22, 2013 12:40 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:57 AM
Points: 2,840, Visits: 3,971
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
Post #1409836
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse