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