Microsoft SQL Server 2000 Administrators Companion

3 4

This object offers useful statistics about SQL statements that have been run. Its counters are as follows:

• Auto-Param Attempts/sec Number of auto-parameterization attempts per second. Auto-parameterization occurs when the optimizer has a cached execution plan of a SQL statement that is similar, but not the same as the one being optimized. The optimizer will attempt to reuse the already optimized plan.
• Batch Requests/sec Number of T-SQL batch requests per second that have been received by the server.
• Failed Auto-Params/sec Number of auto-parameterization attempts that have failed per second.
• Safe Auto-Params/sec Number of safe auto-parameterizations per second.
• SQL Compilations/sec Number of times per second that SQL compilations have occurred. This counter includes recompiles.
• SQL Re-Compilations/sec Number of times per second that SQL recompilations have occurred.
• Unsafe Auto-Params/sec Number of unsafe auto-parameterizations per second