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.
allows you to select the total time an alert is raised for an event.
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:
- to exclude one or more disk drives from triggering an alert
- to exclude certain words and expressions from triggering an alert
allows you to select whether you want SQL Diagnostic Manager to take autogrowth into account when calculating the remaining space available.
allows you to select the databases you want to exclude from database alerts.
allows you to select both the jobs and job categories you want to exclude from job alerts.
allows you to select the applications, host servers, and users you want to exclude from job alerts.
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.