Show information relating to the performance health of the SQL Server. The Performance Health drilldown is designed to provide a high level view of potential bottlenecks.
The Performance Health drilldown assesses data from server level wait statistics (sys.dm_os_wait_stats).
To see the Performance Health drilldown
Click Monitor | Performance Health.
Drilldown | Description | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Rating |
| ||||||||||
Current Wait Rate |
The current wait rate and this as a percentage of total available CPU time. | ||||||||||
Instance Wait Time |
This bar chart provides a visual overview of where most of the wait time is being spent.
| ||||||||||
I/O Latency |
Use this chart to check the responsiveness of the I/O subsystem by measuring the single-block-read latency. I/O latency is low in a healthy system to indicate that the time being spent on I/O is productive. The position of the pin on the chart indicates the current I/O latency. |
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy