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, the IDERA Newsfeed, or SQLDM Mobile.
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
- Send the alert message to the IDERA Newsfeed Action Provider, which publishes the alert message as a status update on the server wall in the IDERA Newsfeed interface and on the Active Alerts view in SQLdm Mobile.
- 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
- Send the alert message to the IDERA Newsfeed Action Provider, which publishes the alert message as a status update on the server wall in the IDERA Newsfeed interface and on the Active Alerts view in SQLdm Mobile.
- 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.
IDERA Newsfeed
The IDERA Newsfeed is a revolutionary new way for DBAs and managers to collaborate, share knowledge, and keep close tabs on your most critical SQL Server issues. With the IDERA Newsfeed, you can quickly share information to stay informed, be more productive and shorten the time to problem resolution.
For more information, see the IDERA Newsfeed Help.
SQLDM Mobile
SQLDM Mobile includes the IDERA Newsfeed as well as several dashboard views that define your server health and expose critical alerts. You can access the SQLDM Mobile Web application from most smart phones and mobile devices.