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.

How to open the Performance Health drilldown

From the Spotlight Client

  1. Select the connection from the left Connections pane.
  2. Click Monitor | Performance Health from the ribbon.
    Performance Health drilldown for SQL Server

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.