Page History

By default, certain metrics include all drives within a specific SQL Server SQL Server instance when monitoring for events that can trigger an alert. The Alert Filters tab of the Advanced Alert Configuration window allows you to select one of more disk drives to exclude from alerting on the selected metric.

Image Added

The alerts that allow for disk drive exclusions include the following:

...

To use ad hoc Alert Configuration to exclude disk drives from an alert:

...

1. Right-click the appropriate SQL server SQL server instance, and then select Configure Alerts .
2. Select the metric for which you want to configure an alert.
3. Select the appropriate disk, click Edit , and then click Advanced.
4. Click the Alert Filters tab.
5. Click Exclude.
6. Select Type one or more disk drives from the list, and then click Excludeto exclude from alerts.
7. Click OK .

To

...

To use Alert Configuration Templates to exclude disk drives from an alert:

1. Click Tools > Click Image Added and select Alert Configuration Templates .
2. Click New or select an existing template, and then click View/Edit . When you click New , type a name, and then click Edit Configuration .
3. Click View/Edit , click Edit Configuration.
4. Select the metric for which you want to configure an alert.
5. Select the appropriate disk, click Edit , and then click Advanced.
6. Click the Alert Filters tab.
7. Type the name of the disk drives you want to exclude from alerts. Use semicolons to separate names and do not use wildcard characters.
8. Click OK.
9. If you want SQL Diagnostic Manager to replicate your edits to every monitored SQL Server instance, click Yes.
10. To accept these changes, click OK.