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 allows you to select the total time an alert is raised for an event.
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 allows you to select:
- 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 allows you to select whether you want SQL Diagnostic Manager to take autogrowth into account when calculating the remaining space available.
Database exclusions allows you to select the databases you want to exclude from database alerts.
Job exclusions allows you to select both the jobs and job categories you want to exclude from job alerts.
Sessions exclusions allows you to select the applications, host servers, and users you want to exclude from job alerts.
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 Tools > Alert Actions and Responses from the console toolbar.