Page tree

SQLdm 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 SQLdm Console, the Idera Newsfeed, or SQLdm Mobile.

When an alert threshold is reached, SQLdm 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 SQLdm 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 SQLdm does not support this feature for new users.

In response to a set threshold entering the error level, SQLdm 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, SQLdm alerts you again if the situation recurs.

On each SQLdm 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

SQLdm 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

SQLdm 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 SQLdm. 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.

 

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