SQL Diagnostic Manager allows you to configure alerts to inform and warn you about approaching issues with your SQL Server instances. You can view these alerts using the SQL Diagnostic Manager Console.
When an alert threshold is reached, SQL Diagnostic Manager can:
- Send an email notification
- Pop up an alert message in your Windows taskbar
- Write an event to the Windows Event log
- Generate an event on the Timeline
- Create a new To Do item
To Do feature
Beginning with SQL Diagnostic Manager 7.0, the To Do feature is available only to users who had To Do activated in an earlier 6.x version. This version of SQL Diagnostic Manager does not support this feature for new users.
In response to a set threshold entering the error level, SQL Diagnostic Manager can perform one or more of the following actions:
- Send an email notification
- Write an event to the Windows Event log
- Generate an event on the Timeline
- Create a new To Do item
Once you correct the situation triggering the alert, SQL Diagnostic Manager alerts you again if the situation recurs.
On each SQL Diagnostic Manager view, columns containing associated alerts are highlighted with their current status color. You can right-click many of these columns and select Configure Alert to change the associated thresholds.
Database- or disk-level alerts
SQL Diagnostic Manager includes some alerts that allow you to set them at a database or disk level, meaning that you can set different alert thresholds for each database or disk within a monitored SQL Server instance.
Alert templates
SQL Diagnostic Manager allows you to configure generic alert settings as a template that you can apply to servers and groups of servers in your organization. Click Tools > Alert Configuration Templates and complete the required fields to configure an alert template.
Informational alerts
Informational alerts allow you to set a threshold that, when generated, triggers a status that does not affect the overall status of the server within SQL Diagnostic Manager. You can use informational alerts to notify an administrator of the state of a particular metric for a server or trigger secondary processes that could take action to prevent issue escalation.
Note that for certain metrics, using the informational alert means that you no longer receive a warning or critical alert for events generated by that metric. Please review the situation before setting up an informational alert.