Skip to main content

SQL Server Performance Metrics

Metric AliasMetric DescriptionUnit
UptimeUptime of this components
VersionSQL Server version
AvailabilitySQL Server availability, normal/abnormal/unmonitored
CPU UsageProcess CPU usage%
Memory UsedProcess memory usageBytes
Memory UsageProcess memory usage / host total memory%
Disk Throughput (Read)Process disk read throughput per secondBytes/s
Disk Throughput (Write)Process disk write throughput per secondBytes/s
Traffic (Send)Bytes sent per second by SQL ServerBytes/s
Traffic (Receive)Bytes received per second by SQL ServerBytes/s
Throughput (QPS)Number of SQL executions per second (CRUD operations)Count/s
Throughput (TPS)Number of transactions per second (commit+rollback)Count/s
Connection RatioConnections / max connections%
User ConnectionsNumber of user connections to databaseCount
Connection Reset CountNumber of connections reset per secondCount/s
Cache Hit RateDatabase cache hit rate%
Full Table Scan CountNumber of full table scans per secondCount/s
Transaction Log UsedSize of used transaction logBytes
Transaction Log TotalTotal size of transaction logBytes
Database SizeDatabase sizeBytes
SQL Compilation CountNumber of SQL compilations per secondCount/s
SQL Recompilation CountNumber of SQL recompilations per secondCount/s
Lock Request CountAverage lock requests per secondCount/s
Deadlock CountAverage deadlocks per secondCount/s
Lock Wait CountAverage lock waits per secondCount/s