Page History
...
If there are no active alerts, you can click a category icon and you are directed to a specific category view in the single instance dashboard. The table below shows the relationship between the category icons and their corresponding views:
| Icon | Category |
|---|---|
 | Sessions tab of the single instance dashboard |
 | Queries tab of the single instance dashboard |
 | Resources tab of the single instance dashboard |
 | Databases tab of the single instance dashboard |
 | Alerts Detail screen |
 | Overview tab of the single instance dashboard |
 | Launch SWA |
| Info |
|---|
Instances in thumbnail sub-view display according to severity. This means that critical instances show up on the top of the dashboard. |
...
- Click Details to access the Overview tab of the single instance dashboard.
- Launch the SQL Diagnostic Manager console by clicking the SQL Diagnostic Manager icon
. - Launch SQL Workload Analysis by clicking the SWA icon .
How to interpret the health index in the heatmap sub-view?
The health index is a percentage value that provides an estimate of the relative health of your monitored SQL Server. The health index is based on the following raw calculation:
| Health Index Raw Calculation = Instance or Tag Scale Factor * (# Critical Alerts * Critical Scale Factor + # Warning Alerts * Warning Scale Factor + # Informational Alerts * Informational Scale Factor) |
The raw score is normalized to a range between 100% and 0%. SQL Server is healthier the closer its health index is to 100%, and it is in critical state the closer its health index is to 0%. Use the severity factors to change the relative weight in the calculation. Use tag and instance factors to assign instances more or less importance in the overall heatmap ranking.
...