none
SQL Compilations/sec

    Question

  •  

    I am experiencing an unusually high number of SQL Compiliations/sec in comparision to Batch Request/sec.  2000 compilations with 3000 batch reqs on average.  I am trying to discover which SQL statements are being compiled by using SQL Profiler trace event "Performance: Showplan XML For Query Compile", but nothing comes back.  I am not filtering on anything in Profiler and Perfmon is reporting the normal 2000 SQL Compilations/sec while I have the trace running.  Any insight into why this would be occuring?  Am I not comparing apples to apples here?
    Tuesday, May 06, 2008 10:52 PM

Answers