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 SQL Diagnostic Manager waits before alerting on a metric that has exceeded threshold limits.

Alert Filters

Alert filters allows you to select:

  • Filter out alerts:
    • Minimum Version Store Size that should be reach before an alert is raised.
    • Minimum Version Store Generation Rate at which an alert should be generated.
  • Disk drive exclusions to exclude one or more disk drives from triggering an alert
  • Text and regular expressions to exclude certain words and expressions from triggering an alert

Autogrow Settings

Autogrow settings allows you to select whether you want SQL Diagnostic Manager to take auto growth 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 SQL Diagnostic Manager generates an alert when a custom counter is not collected.

Configure a custom response when an alert is generated by SQL Diagnostic Manager

SQL Diagnostic Manager 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 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.)

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



SQL Diagnostic Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal