Chat now with support
Chat with Support

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

Configure Spotlight

Configure Spotlight from the Spotlight Client Configure ribbon.

Icon Description

Manage the connections monitored by Spotlight.

Set the thresholds and severities that determine when an alarm is raised. Disable an alarm. Set an alarm to require acknowledgment. Configure keyed alarms. Collect additional diagnostic information on an alarm.

Set actions for Spotlight to take when an alarm is raised. The actions Spotlight can take include running a program and sending an email. Conditions on taking the action can be defined, such as the day of the week, the time of day, the severity of the alarm, the alarm type and the connection type.

Spotlight collects data according to these set schedules.

Enter the scheduled maintenance times for the connections Spotlight monitors so Spotlight does not raise alarms and attempt to collect data during the outage period.

Enable SQL Analysis. Configure the filters used to gather SQL Analysis data.

Set the SQL statement that is used to measure SQL Server response time.


Create and configure Custom Counters for monitoring connections to SQL Servers and Windows servers.


Request Spotlight raise an alarm when a specified entry is logged in the SQL Server error log.

Track the growth of specified files (usually log files) on monitored Windows Servers.

Customize the Spotlight Client look and feel. Configure operations for the Spotlight Diagnostic Server.

Configure operations for the Spotlight Diagnostic Server.

Enable functionality to monitor Spotlight connections from the Spotlight web site or Spotlight Mobile. Upload performance data for health check analysis.

Influence the design of future versions of Spotlight and help us improve its quality, reliability and performance.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating