Microsoft SQL Metrics

Collected

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.

To see a full list of metrics for the Windows Agent, see this page.