Page History
The Total in DB Highlights chart shows a general overview of the following metrics:
- Using CPUInternal Wait - Analyze statements experiencing internal waits.
- I/O Wait
- Log Wait
- OS Wait
- Internal Wait
- Lock 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
This box displays the list of metrics by name and measured by the color-coded bars in the Total in DB column.
Tip |
---|
When you move the cursor over any of the rows that are in the Total in DB column, you get a box with the information about the metric belonging to that row. |
- - Analyze statements experiencing log waits.
- Remote Wait - Analyze statements experiencing waits for remote instances.
...