SQL Compilations/sec RRS feed

  • 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 6, 2008 10:52 PM