The Total in DB Highlights chart shows a general overview of the following metrics:
- Internal Wait - Analyze statements experiencing internal waits.
- I/O Wait - Analyze disks and storage devices experiencing high I/O waits.
- Lock Wait - Analyze current and historical locks.
- Using CPU - Analyze statements with high CPU consumption.
- OS Wait - Analyze statements experiencing OS waits.
- Tempdb I/O Wait - Analyze statements experiencing I/O waits on tempdb.
- Network I/O Wait - Analyze statements experiencing network waits.
- Log Wait - Analyze statements experiencing log waits.
- Remote Wait - Analyze statements experiencing waits for remote instances.
SQL Workload Analysis add-on provides a granular breakdown of wait states with easy drill-down to isolate problems quickly.
IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal