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?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.