How to open the Performance Health drilldown
From the Spotlight Client
- Select the connection from the left Connections pane.
- Click Monitor | Performance Health from the ribbon.
About the Performance Health drilldown
The Performance Health drilldown assesses data from server level wait statistics (sys.dm_os_wait_stats).
rating
Healthy
Database time is being spent productively on CPU and IO.
A performance-health rating of 80% or more is considered healthy.
If no performance-health rating is provided then the load being placed on the database is too low to assess its health. The database performance health is still considered to be healthy.
Unhealthy
Too much database time is spent waiting for bottlenecks such as locks and latches.
The Poor Performance Health alarm is raised.
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.
| Color | Description |
|---|---|
| Green | Bars colored green represent healthy wait time (CPU and I/O). |
| Yellow | If I/O is colored yellow then I/O latency is high. |
| Blue | Bars colored blue represent unhealthy wait time. Categories of unhealthy wait are: Other, Log, CLR, IO, Network, Memory, Latch, Remote Provider, CPU, Lock and XTP. |
Tips to using the Instance Wait Time chart
- The bar chart shows only the categories currently contributing to wait time. The bar chart adjusts itself dynamically in real time.
- Hover the mouse over each bar in turn to see a statistical summary.
- Click on a bar to open the SQL Server | Wait Events drilldown specific to the represented category of wait.
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.