Chat now with support
Chat with Support

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

Configure the Spotlight Management Pack for SCOM

Repeat these steps for each Spotlight Diagnostic Server. The purpose of these steps is to configure SCOM to target the Windows server that hosts the Spotlight Diagnostic Server.

  1. From the SCOM Console, expand Administration | Device Management.
  2. Right click Device Management and select Discovery Wizard… to open the Computer and Device Management Wizard.

Table 2: Complete the Computer and Device Management Wizard

Wizard page Description

Discovery Type

Select Windows computers to discover devices of this type.

Auto or Advanced?

Select Advanced Discovery.

Parameter Description
Computer and Device Classes Select Servers and Clients.
Management Server Select the Windows computer hosting the Spotlight Diagnostic Server. As per the requirements it is recommended that the Spotlight Diagnostic Server and SCOM Management Server are installed on different host computers.

Discovery Method

Select Browse for, or type in computer names.

From the Select Computers dialog select objects of type Computers from the Entire Directory. Enter the name(s) of the computer(s) running a Spotlight Diagnostic Server.

Administrator Account

Select Other User Account. Enter the account details of a Windows user that is a member of the Spotlight Diagnostic Administrators Group for the Spotlight Diagnostic Server.

Select Objects to Manage

Use SCOM Agent or Agentless monitoring.

Option Description
Agent To use SCOM Agent monitoring, set the Management Mode option to Agent. Click Next to open the Summary page of the Computer and Device Management wizard.
Agentless

To use SCOM Agentless monitoring, set the Management Mode option to Agentless. Click Finish to complete the Computer and Device Management wizard.

Summary

The Summary page is applicable to SCOM Agent monitoring.

Verify / Change the Agent installation directory.

Enter credentials for the Agent Action Account. Enter the account details of a Windows user that is a member of the Spotlight Diagnostic Administrators Group for the Spotlight Diagnostic Server and an Administrator on the Spotlight Diagnostic Server host.

Workflow for Spotlight alarms

A new SCOM Spotlight Alert is raised each time a Spotlight alarm is raised or the severity of a Spotlight alarm changes. All Spotlight alarms can be managed through the SCOM alerts work flow.

Monitor Spotlight alarms

Open the SCOM Console. From the Monitoring pane select Active Alerts. Each SCOM alert is listed on the Active Alerts table.

Table 3: Active Alerts table

Spotlight Alerts Description
Source The connection the Spotlight alarm was raised against.
Name The name of the Spotlight alarm.
Resolution State The resolution state of the Spotlight Alert. Note that when the Spotlight alarm is resolved the SCOM Alert is NOT automatically resolved.
Created The date and time the Spotlight Alert was raised.

 

TIP: The visible fields on the Active Alerts table can be personalized with Custom Fields from the Spotlight Alert. For definitions of the Spotlight Alert Custom Fields, right click on a Spotlight Alert in the Active Alerts table and select Properties | Custom Fields.

Table 4: Select a Spotlight Alert on the Active Alerts table to view the Alert Details and Description

Alert Details Description
Diagnostic Server The name of the Spotlight Diagnostic Server. The Spotlight alarm is raised against a connection that is monitored through this Spotlight Diagnostic Server.
Connection The display name of the Spotlight Connection. The Spotlight alarm is raised against this connection.
Technology The Spotlight Connection Type; for example SQL Server or Windows.
Display Name The display name of the Spotlight alarm.
Severity The severity of the Spotlight alarm.
Details The details of the Spotlight alarm.
First Raised The earliest known time the same Spotlight alarm was raised against the connection (as sourced from the Playback Database).
Last Raised The most recent time the same Spotlight alarm was raised against the connection. For an alarm that has been raised repeatedly this could be a more recent time than the time of this alarm.
Is Snoozed True if the Spotlight alarm has been snoozed. The Spotlight Alarm can be snoozed in Spotlight or the SCOM Console.
Snoozed By If the Spotlight alarm Is Snoozed - Snoozed By records the user that snoozed the alarm.
Snoozed Until If the Spotlight alarm Is Snoozed - Snoozed Until records the time the alarm is snoozed till.
Requires Acknowledgment True if the Spotlight alarm is configured to require acknowledgment.

Table 5: Right click a Spotlight Alert on the Active Alerts table for further detail and / or to make changes

Right Click | Select Description
View or edit settings for this rule | Overrides Override parameters of this Spotlight Alert such as priority and severity. Note that the Spotlight Management Pack for SCOM is sealed so an alternative destination management pack is required.

Properties | General

Change the properties of the Spotlight Alert.

Owner Assign an owner to the Spotlight Alert.
Ticket ID Assign a Ticket ID to the Spotlight Alert.
Alert Status Change the Alert status as appropriate.
Properties | Product Knowledge Show help on Spotlight Alerts.
Alert Context Show all details of the Spotlight alarm.
Custom Fields Show details of the Spotlight alarm that can be displayed as Custom Fields on the Active Alerts table.

Spotlight Alerts rule

You may want to override the defaults to the Spotlight Alerts rule. By default: Spotlight Alerts are enabled, have a warning severity, medium priority and the rule is run every 60 seconds. The rule properties for Spotlight Alerts can be overridden for an individual connection, group of connections or globally.

Open the SCOM Console.

  1. From the Authoring pane select Management Pack Objects | Rules. Look for Spotlight Alerts.
  2. Right click on the Spotlight Alerts rule and select Properties.
  3. Open the Overrides tab.
  4. Click Disable to disable the Spotlight Alerts rule. Click Override to override one or more parameters of this rule. Click on an override to override properties of the rule. Note that the Spotlight Management Pack for SCOM is sealed so an alternative destination management pack is required.

Send notifications to subscribers when criteria is matched relating to the Spotlight Alerts rule

Setup SCOM to send notifications when Spotlight Alerts match a defined Subscription criteria.

Open the SCOM Console. Expand Tasks | Subscription, click Create to open the Notification Subscription Wizard.

Table 6: The Notification Subscription Wizard

Wizard page Description
Description Give a name to the Notification Subscription. Optionally, provide a description.

Criteria

Select criteria as appropriate. A notification will be sent on all selected criteria being matched.

In addition to your own criteria, ensure the following criteria are selected.

Criteria Description
raised by any instance in a specific group The Group Search dialog opens when you select this criteria. From the Management Pack dropdown, select Spotlight Management Pack.
raised by instances with a specific name The Object Search dialog opens when you select this criteria. From the Look for dropdown, select Spotlight Management Pack.
Subscribers Add subscribers as appropriate. On all selected criteria being matched, SCOM will send a notification to the selected subscribers.

SCOM Console views of Spotlight

Open the SCOM Console. Expand Monitoring | Quest Spotlight on SQL Server Enterprise. Select from the available SCOM Console views.

SCOM Console View Description

Dashboard

Select to show the Spotlight Diagnostic Servers known to SCOM, the connections monitored by each Spotlight Diagnostic Server and the alarms raised for each connection.

To add a Spotlight Diagnostic Server to SCOM see Configure the Spotlight Management Pack for SCOM.

Diagnostic Servers' Health

Select to show alarms raised against each Spotlight Diagnostic Server. For example, show:

  • Health check data upload alerts
  • Auto update of the Spotlight Diagnostic Server alerts
  • Mobile monitoring data transfer failure alerts
  • Failure to monitor the Spotlight connection
  • Failure to send email notifications of alarms raised

Spotlight Alarms

Select to show in detail alarms raised against monitored Spotlight connections.

  • Show the alarm, the severity of the alarm, the connection the alarm is raised against, a descriptive message of the alarm, the date and time the alarm was raised.
  • Snooze / Unsnooze the alarm. If the alarm is snoozed, show the date and time the alarm is snoozed until.
  • Acknowledge the alarm.

 

Note:

  • The views in the SCOM Console update automatically when an alarm is raised or the alarm status changes.
  • The views in the SCOM Console show all Spotlight connections, including those connections that are disabled and in outage.

Snooze and acknowledge Spotlight alarms

Open the SCOM Console.

  1. Expand Monitoring | Quest Spotlight on SQL Server Enterprise.
  2. Select the Spotlight Alarms view.
  3. Select the alarm in the All Alarms panel.
  4. From the main menu select: Tasks | SoSSE Alarms Class Tasks. Select to snooze, unsnooze or acknowledge the selected alarm.

    Alternatively, from the SCOM Console Tasks Pane click Tasks | SoSSE Alarms Class Tasks to snooze, unsnooze or acknowledge the selected alarm. To open the Tasks Pane, from the SCOM Console main menu click View | Tasks.

Note: This functionality can only be performed one alarm at a time.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating