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.
| Name | Description |
|---|---|
| mssql_batch_requests | Number of command batches received. |
| mssql_buffer_cache_hit_ratio | Ratio of requests that hit the buffer cache |
| mssql_checkpoint_pages_sec | Checkpoint Pages Per Second |
| mssql_connections | Number of active connections. |
| mssql_deadlocks | Number of lock requests that resulted in a deadlock. |
| mssql_io_stall_seconds | Stall time in seconds per database and I/O operation. |
| mssql_io_stall_total_seconds | Total stall time in seconds per database. |
| mssql_kill_connection_errors | Number of severe errors that caused SQL Server to kill the connection. |
| mssql_local_time_seconds | Local time in seconds since epoch (Unix time). |
| mssql_log_growths | Number of times the transaction log has been expanded, per database. |
| mssql_memory_utilization_percentage | The percentage of committed memory that is in the working set. |
| mssql_os_memory | OS physical memory, used and available. |
| mssql_os_page_file | OS page file, used and available. |
| mssql_page_fault_count | The number of page faults that were incurred by the SQL Server process. |
| mssql_page_life_expectancy_seconds | The minimum number of seconds a page will stay in the buffer pool on this node without references. |
| mssql_resident_memory_bytes | SQL Server resident memory size (AKA working set). |
| mssql_user_errors | Number of user errors. |
| mssql_virtual_memory_bytes | SQL Server committed virtual memory size. |