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;-)