Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

Configure an alarm

Configure the conditions for which the alarm is raised. For more information about each alarm, see About each alarm.

Open this screen from the Spotlight Client

  1. Click Configure | Alarms.

  2. Select the connection or template to apply the alarm configuration to.

  3. Double click on the alarm.

Alarm configuration

Control Description

Factory Settings
Select Return the settings for this alarm to the Factory Settings. These are the settings that were shipped with Spotlight.
Clear Modify the settings for this alarm.

 

Note: You cannot modify the Factory Settings Template. If you cannot see an option to clear Factory Settings then you are browsing the Factory Settings Template. To modify the settings for this alarm, close this dialog and select either a Spotlight Connection or a different template from the Configure | Alarms dialog.

Disable this alarm

When selected the alarm will not be raised again for this connection / template.

Only some alarms can be disabled.

Alarm requires acknowledgment

When the severity of the alarm returns to normal, should Spotlight continue to presence the alarm in Spotlight Today and the Spotlight Home Page until it is acknowledged? For more information, see Acknowledge.

Select Select this option when you want to know that the alarm was raised even after the severity returns to normal.
Clear Spotlight removes the alarm from Spotlight Today and the Spotlight Home Page when the severity returns to normal.

Add and Delete keys

Key values can be added to some alarms. Where applied, the thresholds are set for each key independent of each other.

A key is a unique value that identifies a particular row in a collection. For example, database name is the key for Databases alarms. Take an example where the standard backup schedule for databases is weekly but one particular database is backed up monthly. You can configure a specific threshold for that database (in this scenario 30 days) independent of the default severity (in this scenario 7 days).

Control Description

Key Value list

A list of keys that have been configured for this alarm.

All alarms have a Default Severity.

Keys that have been added are listed here. Thresholds are applied independently to each key. Select the key to apply the thresholds to.

TIP: You can use keys to configure alarms to ignore certain values. For more information, see Do not alarm for certain values.

Add Click to add keys. (Applicable to alarms that can be configured with keys.)
Delete Click to delete the selected key. (You cannot delete the Default Severity.)

Configure thresholds / set the severity

Dependent on the alarm, configuration is applied by adjusting thresholds or selecting a severity from the severity list.

Dialog Description

This alarm is raised with increasing severity dependent on a numeric value. Spotlight uses a threshold bar to illustrate the severity thresholds. For more information, see Severity thresholds.

This alarm is raised to a single severity.

Severity Select the severity to apply when the alarm is raised.
Message Add message text to the Message field. Message text is displayed in the Details column of the Alarm Log when the alarm is raised. To include variables in the text see Alarms - Message Variables.

Actions

Control Description

Collect additional diagnostic information
Select Collect additional data in the Playback Database to assist you in resolving the root cause of the alarm. For more information, see Collect additional diagnostic information.
Clear You may choose to turn the option off to conserve space in the Playback Database.

Not all alarms have the option to collect additional information.

Do not raise an alarm for certain values

Click Values to specify the values that Spotlight should ignore when an alarm is raised. You can use wildcard characters when specifying values to ignore. For more information, see Do not alarm for certain values.

Not all alarms have this option.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating