Skip to main content
Version: 24.11.01

Metrics

Microsoft SQL Server is a relational database management system known for its performance and security. Monitoring its metrics is crucial to ensure performance, stability, and reliability. The following is a list of essential SQL Server metrics in PDS. Understanding these metrics will help administrators optimize performance, troubleshoot issues, and ensure the SQL Server runs smoothly.

NameDescription
mssql_batch_requestsNumber of command batches received.
mssql_buffer_cache_hit_ratioRatio of requests that hit the buffer cache
mssql_checkpoint_pages_secCheckpoint Pages Per Second
mssql_connectionsNumber of active connections.
mssql_deadlocksNumber of lock requests that resulted in a deadlock.
mssql_io_stall_secondsStall time in seconds per database and I/O operation.
mssql_io_stall_total_secondsTotal stall time in seconds per database.
mssql_kill_connection_errorsNumber of severe errors that caused SQL Server to kill the connection.
mssql_local_time_secondsLocal time in seconds since epoch (Unix time).
mssql_log_growthsNumber of times the transaction log has been expanded, per database.
mssql_memory_utilization_percentageThe percentage of committed memory that is in the working set.
mssql_os_memoryOS physical memory, used and available.
mssql_os_page_fileOS page file, used and available.
mssql_page_fault_countThe number of page faults that were incurred by the SQL Server process.
mssql_page_life_expectancy_secondsThe minimum number of seconds a page will stay in the buffer pool on this node without references.
mssql_resident_memory_bytesSQL Server resident memory size (AKA working set).
mssql_user_errorsNumber of user errors.
mssql_virtual_memory_bytesSQL Server committed virtual memory size.
Was this page helpful?