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