Chat now with support
Chat with Support

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


The Spotlight Management Pack for SCOM is appropriate for organizations that use SCOM (System Center Operations Manager) as their centralized monitoring system and wish to use Spotlight as their tool of choice for SQL Server monitoring.

Refer to this guide for installation and usage of the Spotlight Management Pack for SCOM.


Following deployment of the Spotlight Management Pack for SCOM you will be able to use a SCOM Console to:

  • Manage a work flow of Spotlight alarms through SCOM alerts (for example raise SCOM tickets).
  • View data from monitored Spotlight connections.
  • Snooze, unsnooze and acknowledge raised Spotlight alarms.


The Spotlight Management Pack for SCOM requires the following:

Table 1: Requirements

Requirement Details


SCOM (System Center Operations Manager) 2012 and above as deployed in your organization.


Spotlight on SQL Server Enterprise 11 or later.

Spotlight on SQL Server Enterprise 11.1 or later is required to snooze / unsnooze and acknowledge alarms.

In the deployment of Spotlight, consider the following:

  • It is recommended that the Spotlight Diagnostic Server and SCOM Management Server be installed on different host computers.
  • The Spotlight Client is required to configure Spotlight, manage Spotlight connections and configure alarms.
  • The Spotlight Client is not required by SCOM. The SCOM Console and SCOM Management Server communicate directly with the Spotlight Diagnostic Server.

User Privileges

The Windows user(s) running the SCOM Console and SCOM Management Server must be member(s) of the Spotlight Diagnostic Administrators Group for each Spotlight Diagnostic Server. This ensures that a secure connection to the Spotlight Diagnostic Server can be made through Port 40403 and that Spotlight information can be retrieved. For more information on the Spotlight Diagnostic Administrators Group, refer to the Spotlight on SQL Server Deployment Guide.

Unpack the Spotlight Management Pack for SCOM

On the Windows server where the SCOM Console is installed:

  1. Unzip the contents of to a known directory.
  2. Create an Environment Variable called sosse_mp_path. Set the Environment Variable value to the directory above. This Environment Variable is required to snooze, unsnooze and acknowledge alarms from the SCOM application.

Open the SCOM Console:

  1. Expand Administration.
  2. Select Management Packs.
  3. Right click Management Packs and select to import the Quest.SoSSE.mpb management pack from the directory created above.
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating