SQL Diagnostic Manager collects a number of SQL Server and operating system performance metrics to help you monitor, alert, and report on your system health. SQL Diagnostic Manager includes a number of metrics for your use, such as:

• Batches Received (Per Second)
• Blocked Sessions (Count)
• Buffer Cache Hit Ratio (Percent)
• Client Computers
• SQL Compilations (Per Second)
• Data Used (Percent)
• Database Status
• Disk Queue Length
• Disk Time (Percent)
• I/O Waits
• Lock Waits
• Log Flushes
• Log Space Used (Percent)
• Memory Page Faults (Per Second)
• Memory Paging
• Memory Waits
• Other Waits
• Packets Received (Per Second)
• Packets Sent and Received
• Packets Sent (Per Second)
• Page Reads (Per Second)
• Page Writes (Per Second)
• Percent of SQL Server Data Space Used
• Percent of SQL Server Log Space Used
• Physical Page Reads and Writes
• Processor Queue Length
• Re-compiles Per Second
• Signal Waits
• SQL Server Batches Received
• SQL Server CPU Usage
• SQL Server Log Space Used (Percent)
• SQL Server Memory Usage
• SQL Server Response Time
• Total Memory Usage
• Transaction Log Waits
• Transactions (Per Second)
• Wait type category - Backup
• Wait type category - I/O Page Latch
• Wait type category - Lock
• Wait type category - Memory
• Wait type category - Non-I/O Page Latch
• Wait type category - Non-Page Latch
• Wait type category - Other
• Wait type category - Transaction Log