Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The thumbnail sub-view provides you with a graphical replication of your monitored SQL servers. Access additional details in the single instance dashboard  by clicking on a thumbnail’s instance name or easily spot categories that have active alerts as marked by a critical icon. Navigate to an instance’s specific category view in case it has active alerts by clicking on the marked category icon.

...

If the category icon contains active alerts, you can choose the Show Alert link to access the Alerts Detail screenIf 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:

IconCategory
Image Modified
Sessions tab of the single instance dashboard
Image Modified
Queries tab of the single instance dashboard
Image Modified
Resources tab of the single instance dashboard
Image Modified
Databases tab of the single instance dashboard
Image Modified
Alerts Detail screen
Image Modified
Overview tab of the single instance dashboard
Info

Instances in thumbnail sub-view display according to severity. This means that critical instances show up on the top of the dashboard.

...

The following colors in the heatmap sub-view are associated with a status and action within SQLdm:

ColorMeaning
Green Acceptable threshold where SQLdm does not generate an alert.
Yellow Warning threshold where SQLdm generates a warning alert.
Red Critical threshold where SQLdm generates a critical alert.
Orange Monitored SQL Server in maintenance mode where SQLdm does not generate an alert.

To access basic statistics about your monitored SQL Servers, first expand the heatmap of your choice by clicking the instance name. The information displayed includes:

...

If the category icon contains active alerts, you can choose the Show Alert link to access the Alerts Detail screenIf 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 in the heatmap sub-view:

IconCategory
Image Modified
Sessions tab of the single instance dashboard
Image Modified
Queries tab of the single instance dashboard
Image Modified
Resources tab of the single instance dashboard
Image Modified
Databases tab of the single instance dashboard
Image Modified
Alerts Detail screen
Image Modified
Overview tab of the single instance dashboard
Info

Instances in heatmap sub-view display according to severity.

 


SQL  Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >