Metrics are collected for the MS SQL application service.

Table 1. MS SQL Metrics
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.