Chat now with support
Chat with Support

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

Alarms by time

Alarms by Time tracks the start time, duration, and severity of logged alarms.

Your view of monitored connections

Click Monitor | Alarms by Time from the Spotlight ribbon to show all monitored connections in Alarms by Time.

Alarms by Time 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 Alarms by Time from the display pane.

To open Alarms by Time for just one connection, right click on the connection in the Connections pane (Monitored connections) and select Alarms by Time.

Features of the display

Feature Description

Time scale

This spans the top of the chart from left to right, and indicates when alarms (represented as colored horizontal bars) are raised, changed and canceled.

List of connections and alarms

The vertical axis of the chart contains a tree structure. The roots of the tree represent monitored connections; the branches represent the alarms that have been raised against the connection. The list of alarms is re-ordered in real time to show the most recently raised alarms first.

Severity of alarms

The color of the horizontal alarm bars reflect the severity of the alarm. The color changes when the severity changes. The image below shows the Threads alarm which was initially raised with High severity, and was thereafter downgraded in a series of steps to Information status, and then canceled.

Alarms by Time toolbar

Click on the magnifying glass icon to zoom in and out on the displayed time. Alternatively, click the down arrow to choose a suitable time scale.

TIP: Spotlight connections can be sorted in ascending or descending order. For more information, see Sort the grid.

Filter alarms by time

Filter the alarms by time display from the Filter ribbon group.

Ribbon Select Description

Filter by Severity

Show alarms of a certain severity.

Hide Snoozed Alarms

Remove snoozed alarms from the grid.

Actions on the alarms by time display / 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 an alarm

Configure the selected alarm by opening the Alarms dialog.

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 Alarm Log

Alarm log

Show the alarm in the alarm log.


Find text

Find text in the display.

Collapse All

Tree view

Collapse the tree view of the display.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating