Versions Compared

Key

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

...

Note

Be sure to review a list of the default alert IDs, their descriptions, and associated events before configuring your alerts.

You can set the acceptable thresholds using the following alert types:

Alert Type

Color

Meaning

OK

Green

Acceptable threshold where SQL Diagnostic Manager does not generate an alert.

Informational

Blue

Informational threshold where SQL Diagnostic Manager generates an informational alert.

Warning

Yellow

Warning threshold where SQL Diagnostic Manager generates a warning alert.

Critical

Red

Critical threshold where SQL Diagnostic Manager generates a critical alert.


In addition to setting the thresholds for specific alerts, you can customize your alerts by adding comments to each alert. Comments allow you to include instructions to users when a level reaches a particular threshold or to provide additional information about the alert. You can also customize the levels at which SQL Diagnostic Manager provides alert notifications by changing the informational, warning, and critical values either on the Configuration tab of the Alert Configuration window or, for database- and disk-level alerts, on the Database Threshold Configuration window available by selecting the database or disk, and then clicking Edit.

You can also base your alerts on the past performance of the metrics collected by SQL Diagnostic Manager. This is a powerful and effective way to make sure that the alerts you receive are outside of your typical metric ranges.

...

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