MS SQL Server Perfmon SQL Statistics (MSSQL_SERVER_PERFMON_SQL_STATISTICS)
The MSSQL_SERVER_PERFMON_SQL_STATISTICS application class provides counters to monitor compilation and the type of requests sent to an instance of SQL Server.
Monitoring the number of query compilations and recompilations and the number of batches received by an instance of SQL Server gives you an indication of how quickly SQL Server is processing user queries and how effectively the query optimizer is processing the queries.
Application class attributes
Item | Description |
|---|---|
Active | Yes |
Created by | Discovery |
Parent class | MSSQL_SERVER_PERFMON_CONTAINER |
Child class | None |
Attributes (parameters)
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*