High Volume of SQL Compilations/sec

  • 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

  • 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.

  • 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