Metrics are collected for the Microsoft SQL Server application service.
| Metric Name | Category | KPI |
|---|---|---|
| CPU<InstanceName>|CPU Usage (%) | Microsoft SQL Server | False |
| Database IO|Rows Reads Bytes/Sec | Microsoft SQL Server | False |
| Database IO|Rows Reads/Sec | Microsoft SQL Server | False |
| Database IO|Rows Writes Bytes/Sec | Microsoft SQL Server | False |
| Database IO|Rows Writes/Sec | Microsoft SQL Server | False |
| Performance|Access Methods|Full Scans per second | Microsoft SQL Server | False |
| Performance|Access Methods|Index Searches | Microsoft SQL Server | False |
| Performance|Access Methods|Page Splits per second | Microsoft SQL Server | False |
| Performance|Broker Activation|Stored Procedures Invoked per second | Microsoft SQL Server | False |
| Performance|Buffer Manager|Buffer cache hit ratio (%) | Microsoft SQL Server | True |
| Performance|Buffer Manager|Checkpoint Pages/sec | Microsoft SQL Server | True |
| Performance|Buffer Manager|Lazy writes per second | Microsoft SQL Server | True |
| Performance|Buffer Manager|Page life expectancy | Microsoft SQL Server | True |
| Performance|Buffer Manager|Page lookups per second | Microsoft SQL Server | False |
| Performance|Buffer Manager|Page reads per second | Microsoft SQL Server | False |
| Performance|Buffer Manager|Page writes per second | Microsoft SQL Server | False |
| Performance|Databases|Active Transactions | Microsoft SQL Server | True |
| Performance|Databases|Data File(s) Size | Microsoft SQL Server | True |
| Performance|Databases|Log Bytes Flushed/Sec | Microsoft SQL Server | False |
| Performance|Databases|Log File(s) Size | Microsoft SQL Server | False |
| Performance|Databases|Log File(s) Used Size | Microsoft SQL Server | False |
| Performance|Databases|Log Flush Wait Time | Microsoft SQL Server | False |
| Performance|Databases|Log Flushes per second | Microsoft SQL Server | False |
| Performance|Databases|Transactions per second | Microsoft SQL Server | False |
| Performance|Databases|Write Transactions per second | Microsoft SQL Server | False |
| Performance|Databases|XTP Memory Used | Microsoft SQL Server | False |
| Performance|General Statistics|Active temp Tables | Microsoft SQL Server | False |
| Performance|General Statistics|Logins per second | Microsoft SQL Server | False |
| Performance|General Statistics|Logouts per second | Microsoft SQL Server | False |
| Performance|General Statistics|Processes Blocked | Microsoft SQL Server | False |
| Performance|General Statistics|Temp Tables Creation Rate | Microsoft SQL Server | False |
| Performance|General Statistics|User Connections | Microsoft SQL Server | False |
| Performance|Locks|Average Wait Time | Microsoft SQL Server | False |
| Performance|Locks|Lock Requests per second | Microsoft SQL Server | False |
| Performance|Locks|Lock Wait Time | Microsoft SQL Server | True |
| Performance|Locks|Lock Waits per second | Microsoft SQL Server | True |
| Performance|Locks|Number of Deadlocks per second | Microsoft SQL Server | True |
| Performance|Memory Manager|Connection Memory | Microsoft SQL Server | False |
| Performance|Memory Manager|Lock Memory | Microsoft SQL Server | False |
| Performance|Memory Manager|Log Pool Memory | Microsoft SQL Server | False |
| Performance|Memory Manager|Memory Grants Pending | Microsoft SQL Server | True |
| Performance|Memory Manager|SQL Cache Memory | Microsoft SQL Server | False |
| Performance|Memory Manager|Target Server Memory | Microsoft SQL Server | True |
| Performance|Memory Manager|Total Server Memory | Microsoft SQL Server | True |
| Performance|Resource Pool Stats|internal|Active memory grant amount | Microsoft SQL Server | False |
| Performance|Resource Pool Stats|internal|CPU Usage Percentage (%) | Microsoft SQL Server | False |
| Performance|Resource Pool Stats|internal|Disk Read Bytes per second | Microsoft SQL Server | False |
| Performance|Resource Pool Stats|internal|Disk Read IO | Microsoft SQL Server | False |
| Wait Stats:<InstanceName>|Wait Time (ms) | Microsoft SQL Server | False |
| Wait Stats<InstanceName>|Number of Waiting tasks (ms) | Microsoft SQL Server | False |
| Performance|Resource Pool Stats|internal|Disk Read IO Throttled Per Second | Microsoft SQL Server | False |
| Performance|Resource Pool Stats|internal|Disk Write Bytes per second (Bps) | Microsoft SQL Server | False |
| Performance|Resource Pool Stats|internal|Disk Write IO Throttled per second | Microsoft SQL Server | False |
| Performance|Resource Pool Stats|internal|Used Memory | Microsoft SQL Server | False |
| Performance|SQL Statistics | Batch Requests Per Second | Microsoft SQL Server | False |
| Performance|SQL Statistics | SQL Compilations per second | Microsoft SQL Server | False |
| Performance|SQL Statistics | SQL Re-Compilations per second | Microsoft SQL Server | False |
| Performance|Transactions | Free space in tempdb (KB) | Microsoft SQL Server | False |
| Performance|Transactions | Transactions | Microsoft SQL Server | False |
| Performance|Transactions | Version Store Size (KB) | Microsoft SQL Server | False |
| Performance|User Settable Counter | User Counter 0 to 10 | Microsoft SQL Server | False |
| Performance|Workload Group Stats|internal|Active Requests | Microsoft SQL Server | False |
| Performance|Workload Group Stats|internal|Blocked Tasks | Microsoft SQL Server | False |
| Performance|Workload Group Stats|internal|CpU Usage (%) | Microsoft SQL Server | False |
| Performance|Workload Group Stats|internal|Queued Requests | Microsoft SQL Server | False |
| Performance|Workload Group Stats|internal|Request Completed/sec | Microsoft SQL Server | False |
| Application Availability | Microsoft SQL Server | False |
There are no metrics collected for Microsoft SQL Server Database.
