Versions Compared

Key

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

The Alerts tab of the single instance dashboard displays a color-coded alerts timeline view and an active alerts panel for the selected instance.

Info
titleSQL Workload Analysis

 You can launch SQL Workload Analysis from the SQLDM web console single instance view and its tabs. The icon Launch SWA located on the top-right side of the screen is available when your instance is registered in SQL Workload Analysis product.

Color-coded alerts timeline view

The color-coded alerts timeline view allows you to easily identify the highest alert for your monitored SQL Server instance and the highest alert for a specific category. Each color in the alert timeline represents a different alert type. See the following table for more details:

Alert typeColorMeaning
OK Green The alert is in an acceptable threshold.
Warning Yellow The alert reaches a Warning threshold.
Critical Red The alert reaches a Critical threshold.

Filter your alert results in the Alerts tab by specifying a timeframe or by selecting default timeframes of 8 hours, 1 day, 5 days, or 4 weeks. Click image to display in full - size view.

Image AddedImage Removed

You can also filter your alert results by alert category or categories’ order. Click Edit to order and select the categories you want to display in the Alerts timeline view.

Image Added
Image Removed 

Active alerts panel

...

Alert type

Shows alert type icon:Image Modifiedfor OK alerts, for Warning alerts, and for Critical alerts.

...

Displays the name of the monitored SQL Server instance.

Database

Displays the database name.

Category

Indicates alert category.

...

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