Microsoft SQL Server
Microsoft SQL Server metrics come packaged with the Metricly Windows agent. Our Windows agent is a Microsoft Windows service that collects, aggregates, and publishes windows performance counters and attributes. For more information on the Agent itself as well as any plugins available, see the Windows Agent page.
There’s no additional configuration necessary for the Microsoft SQL Server if you’ve already installed the Windows agent unless you want to add additional custom metrics to supplement the default collected metrics.
Additional Configuration Options
For information on all the additional configuration options available, see the Windows Agent page.
The SQL Server metrics are a small subset of the available Windows metrics.
|Category||Instance||Fully Qualified Name (FQN)||Description|
|Process||sqlserver||sql_server.percent_processor_time||The percentage of time the processor is busy.|
|General Statistics||N/A||sql_server.user_connections||The number of users currently connected to the SQL Server.|
|General Statistics||N/A||sql_server.processes_blocked||The number of processes that are blocked.|
|Locks||_Total||sql_server.total_lock_waits_per_sec||The number of locks per second that had to wait for resources.|
|SQL Statistics||N/A||sql_server.batch_requests_per_sec||The number of batches the server is receiving per second.|
|SQL Statistics||N/A||sql_server.sqL-compilations_per_sec||The number of SQL compiles per second.|
|SQL Statistics||N/A||sql_server.sql_recompilations_per_sec||The number of SQL recompiles per second.|
|Buffer Manager||N/A||sql_server.checkpoint_pages_per_sec||The number of pages written to disk per second by a checkpoint operation.|
|Buffer Manager||N/A||sql_server.buffer_cache_hit_ratio||The ratio of how many pages are going to memory versus the disk.|
|Buffer Manager||N/A||sql_server.page_life_expectancy||The number of seconds a page is in the buffer pool without references.|
|Access Methods||N/A||sql_server.page_splits_per_sec||The number of page splits occurring per second.|
For information on manually installing the Windows Agent, checking the version of your agent, adding custom metrics, and more, see the Windows Additional Information page.