Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

Alarm log

The alarm log is a display of logged alarms.

Your view of monitored connections

Click Monitor | Alarm Log from the Spotlight ribbon to show all monitored connections in the alarm log.

The alarm log can show a custom view (Custom views) of monitored connections. Click on a custom view or connection type from the Connections pane (Monitored connections) then click Alarm Log from the display pane.

To open the alarm log for just one connection, right click on the connection in the Connections pane (Monitored connections) and select Alarm log.

About the alarm log grid

The alarm log grid is made up of rows and columns where each row represents an alarm and each column information about that alarm.

Note: By default the alarm log grid is filtered to show alarms raised and canceled in the last 15 minutes. Use Filter by Time to extend this time period. If a long period of time is selected and a large number of connections are monitored then the alarm log may take some time to load.

 

Column Help Reference Description

Time

 

The time the alarm was raised or canceled.

Connection

Monitored connections

The connection the alarm was raised on.

Connection Type

Monitored connections

The type of connection the alarm was raised on (for example, SQL Server). This column is hidden by default.

Details

Spotlight alarms

A brief description of the cause of the alarm. For more information, right click on the alarm and select What's This?.

Severity

 

The degree of urgency of the alarm. The color used depends on the severity of the alarm.

Alarm

About each alarm

The name of the alarm.

Snoozed By

Snooze

The user who requested the alarm be snoozed.

Snoozed Until

Snooze

The alarm is snoozed until this time.

Acknowledged by

Acknowledge

The user who acknowledged the alarm.

Acknowledgment Comment

Acknowledge

The comment entered by the user when they acknowledged the alarm.

When you acknowledge the alarm you are given the opportunity to (optionally) enter a comment.

TIP: The alarm log can be saved to a file or the clipboard. For more information, see Save to file.

Some columns may be hidden by default. To show / hide columns on the grid, right-click the grid headings and select Organize Columns.

Filter the alarm log

Filter the Alarm log from the Filter ribbon group.

Ribbon Select Description

Filter by Severity

Show alarms of a certain severity.

Filter by Time

Show alarms raised and canceled in the last 15 minutes, 30 minutes, 1 hour, 1 day, 1 week. Select All to show all alarms raised and canceled in the alarm log.

Note: The alarm log may take some time to load depending on the number of connections monitored and filter time selected. By default the alarm log is filtered to show alarms raised and canceled in the last 15 minutes.

Hide Snoozed Alarms

Remove snoozed alarms from the grid.

Actions on the alarm log / selected alarm(s)

These actions are selectable from the Action ribbon group. Some actions are enabled only when an alarm is selected.

Icon Ribbon Select Help Reference Description

Diagnose

Connection drilldowns

Show the drilldown relevant to the selected alarm.

Alarm Settings

Configure | Alarms

Configure the selected alarm.

Ignore this Alarm

 

Configure Spotlight to ignore this alarm and future cases of this alarm. Select the rule by which you want Spotlight to ignore future cases of this alarm: ignore this alarm for the current value or for the current connection. The choices are dependent on the type of alarm. This is a simplified interface for Configure | AlarmsDo not alarm for certain values.

Show in Alarms by Time

Alarms by time

Show the alarm in alarms by time.

Find

Find text

Find text in the display.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating