Configure an Alarm to Ignore Certain Values
Some alarms in Spotlight can be configured to ignore certain values so that alarms are not raised, for example, against a particular database or file.
The following alarms can be configured to ignore values:
- Backup - Days Since Last Full Backup
- Backup - Hours Since Last Differential Backup
- Backup - Minutes Since Last Log Backup
- Command - Long Running Command
- CPU - Individual CPU Usage
- Cubes - Days Since Last Processed
- Cubes - Unprocessed
- Custom Counters
- Databases - Data File Group Space Used
- Databases - Dynamic Data File Group Growths Remaining
- Databases - Dynamic Log File Growths Remaining
- Databases - Log File Space Used
- Databases - Log Flush Wait Time
- Databases - Unavailable
- Diagnostic Server - Alarm Action Failure
- Diagnostic Server - Alarm Evaluation Failure
- Diagnostic Server - Collection Execution Failure
- Diagnostic Server - Email Service
- Diagnostic Server - Spotlight Playback
- Disks - Percentage Used
- File - Exceeded Set Size
- Locks - Blocked Processes
- Log Shipping - Primary Backup Job
- Log Shipping - Secondary Job
- Log Shipping - Secondary Latency
- Mirroring - State
- Mirroring - Unrestored Log
- Mirroring - Unsent Log
- Monitored Server - Alarm Action Failure
- Monitored Server - Alarm Evaluation Failure
- Monitored Server - Collection Execution Failure
- Monitored Server - Connection Failure
- Network - Percentage Bandwidth
- Paging - Disk Activity
- Paging - File Collision
- Services - Service Not Running
- SQL - Long Running SQL
- SQL Agent - Jobs Failed
- SQL Agent - Long Running Jobs
Tip: If the alarm is current, you can set Spotlight to ignore the alarm from Spotlight Today. To do this click Monitor | Spotlight Today, right-click the alarm and select Ignore this Alarm for this Key.
To configure an alarm to ignore certain values
-
Click Configure | Alarms.
- Choose one of the following from the connection list:
- To configure the alarm for an individual connection, select the connection name.
- To configure the alarm for all connections, select Default Settings.
- To configure a Spotlight Diagnostic Server alarm, select Diagnostic Server.
- Select an alarm.
- Select Override the default settings for the alarm.
- Click values in the sentence Do not alarm for certain values in the lower pane.
- Select or type the value you want Spotlight to ignore when it raises alarms. You can use wildcard characters when specifying values to ignore. See the next section in this topic.
- Click Add.
Tip: To stop ignoring alarms for certain values, complete steps 1-7 in the procedure above. At step 8, select Delete.
Using Wildcard characters
You can use the following wildcards when specifying values to ignore:
|
* |
Represents any string including the null string. |
|
? |
Represents any single character. |
|
[] |
Matches any one of the enclosed characters. A pair of characters separated by "–" matches any character lexically between the pair. |
For example, type "Database*" in the value field to ignore a series of databases named "Database01" through to "Database99".
Notes
- The exclusion list is not case sensitive. Therefore, both [a-z] and [A-Z] match any letters. For example, [a-z] and [A-Z] work equally.
- “!” following “[“ is not treated as the special symbol that excludes following characters in the brackets, but treated as a single character “!”.
Related Topics
Configure Keyed Alarms (page 1)
Configure Alarms (page 1)
Alarms Dialog (page 1)
Alarms Ribbon Group (page 1)
