2 Microsoft SQL Server Metrics

This chapter provides descriptions for all Microsoft SQL Server metric categories, and the tables list and describe associated metrics for each category. Shaded rows represent key columns for a particular category.

• Viewing Metrics

• Access Methods

• Active SQL Cluster Node

• Agent Status

• Associated Services

• Blocked Session History

• Buffer Manager

• Cache Manager

• Cluster Active Group and Node

• Cluster Active Resource and Node Metrics

• Cluster Name and Network

• Cluster Quorum Resource and Cluster Name

• Cluster Resource and Group

• Cluster Resource and Type

• Cluster Resource Group and Cluster Name Metrics

• Cluster Resource and Owner Node Name

• Cluster Resource and Cluster Name

• Cluster Resource Group and Preferred Node

• Cluster Resources

• Configuration Metrics

• Connection Statistics

• Database

• Database Backup

• Database IOPS Metrics

• Database I/O by File Type

• Database Job

• Database Lock

• Database Parameter

• Database Performance

• Database Status

• Detailed Response

• Event Log Entry

• File I/O Statistics

• General Statistics

• HADR Availability Groups

• HADR Availability Group Replica Databases

• HADR Cluster Members

• Index/Table Fragmentation Metrics

• Index Usage

• Last Database Backup

• Latches

• Latch Wait Time

• Login

• Memory Manager

• Memory Statistics

• Memory Usage

• Mirroring Monitoring

• Mirroring Statistics

• Missing Indexes

• MSSQL Database File

• MSSQL File Group

• MSSQL Transaction Log

• Processor

• Query Plan Statistics

• Response

• Server Statistics Metrics

• Space Usage

• SQL Cluster Nodes Information

• SQL Cluster Number of Nodes

• SQL Instance Statistics

• SQL Server Process Statistics

• SQL Server Backups

• SQL Server Locks

• SQL Server Process

• SQL Server Role

• SQL Statistics

• Top Queries by CPU Time Metrics

• Top Queries by Execution Count

• Top Queries by Total Blocked Time

• Top Sessions by CPU Utilization

• Top Sessions by Memory Utilization

• User

• Wait Type History

• Windows Cluster Name

• Windows Cluster Nodes

• Windows Cluster Number of Nodes