The Advanced Alert Settings window allows you to control how and when alerts are raised by limiting the number of alerts and notifications that are generated.

Alert Duration

Alert duration allows you to select the total time an alert is raised for an event.

Alert Suppression

Alert suppression allows you to select the amount of time SQLdm waits before alerting on a metric that has exceeded threshold limits.

Alert Filters

Alert filters allows you to select:

Autogrow Settings

Autogrow settings allows you to select whether you want SQLdm to take autogrowth into account when calculating the remaining space available.

Database Exclusions

Database exclusions allows you to select the databases you want to exclude from database alerts.

Job Exclusions

Job exclusions allows you to select both the jobs and job categories you want to exclude from job alerts.

Sessions Exclusions

Sessions exclusions allows you to select the applications, host servers, and users you want to exclude from job alerts.

Custom Counters

Custom counters allows you to select whether SQLdm generates an alert when a custom counter is not collected.

Configure a custom response when an alert is generated by SQLdm

SQLdm allows you to configure when and how alert responses are generated. You can select from the following alert responses (providers):

  • Send an email to a person or group of people
  • Log an event in the Windows Event Log
  • Enable the Query Monitor
  • Execute a program or utility
  • Send an event to your Network Management tool
  • Execute a SQL Agent Job
  • Execute a Script
  • Create a To Do (Note that 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.)

To configure a custom response when an alert is generated, select Tools > Alert Actions and Responses from the console toolbar.

 

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