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
- Compiles (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