InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 16:45:23 GMT20http://www.sqlservercentral.com/Forums/Topic1407665-65-1.aspx[quote][b]Imke Cronje (1/16/2013)[/b][hr]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.[/quote] There could be many reasons for this. like memory issues , tempdb issues . see the link [url]http://www.mssqltips.com/sqlservertip/2316/how-to-identify-sql-server-cpu-bottlenecks/[/url]Tue, 22 Jan 2013 00:40:12 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1407665-65-1.aspxHave 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.Wed, 16 Jan 2013 02:23:16 GMTShineBoyhttp://www.sqlservercentral.com/Forums/Topic1407665-65-1.aspxhi 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?RegardsICWed, 16 Jan 2013 01:26:26 GMTImke Cronje