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:
- Average Disk Milliseconds Per Read
- Average Disk Milliseconds Per Transfer
- Average Disk Milliseconds Per Write
- Disk Reads Per Second
- Disk Transfers Per Second
- Disk Writes Per Second
- OS Average Disk Queue Length Per Disk (Count)
- OS Disk Free Space (Size)
- OS Disk Full (Percent)
- OS Disk Time Per Disk (Percent)
To use ad hoc Alert Configuration to exclude disk drives from an alert:
- Right-click the appropriate SQL server instance, and select Configure Alerts.
- Select the metric for which you want to configure an alert.
- Select the appropriate disk, Edit, and click Advanced.
- Click the Alert Filters tab.
- Type one or more disk drives to exclude from alerts.
- Click OK.
To use Alert Configuration Templates to exclude disk drives from an alert:
- Click the
icon and select Alert Configuration Templates. - Click New or select an existing template and then click View/Edit. When you click New, type a name, and click Edit Configuration.
- Click View/Edit and click Edit Configuration.
- Select the metric for which you want to configure an alert.
- Select the appropriate disk, Edit, and click Advanced.
- Click the Alert Filters tab.
- Type the name of the disk drives you want to exclude from alerts. Use semicolons to separate names and do not use wildcard characters.
- Click OK.