Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

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



The time the alarm was raised or canceled.


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.


Spotlight alarms

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



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


About each alarm

The name of the alarm.

Snoozed By


The user who requested the alarm be snoozed.

Snoozed Until


The alarm is snoozed until this time.

Acknowledged by


The user who acknowledged the alarm.

Acknowledgment Comment


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


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 text

Find text in the display.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating