By default, certain metrics include all drives within a specific 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.

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. In the Navigation page, click Servers.
  2. Right-click the appropriate SQL server instance, and then select Configure Alerts.
  3. Select the metric for which you want to configure an alert.
  4. Select the appropriate disk, click Edit, and then click Advanced.
  5. Click the Alert Filters tab.
  6. Click Exclude.
  7. Select one or more disk drives from the list, and then click Exclude.
  8. Click OK.
  9. To accept these changes, click OK.

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

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


SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >