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?
