Chat now with support
Chat with Support

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

Spotlight home page

The Spotlight home page is a graphical display of one monitored connection. The display is made up of flows and components updated in real time to highlight obvious bottlenecks and problem areas.

To see the Spotlight home page

  1. Select a monitored connection (Monitored connections).
  2. Click Monitor | Home.

Home page components

Each Spotlight home page component has various associated statistics. Hover the mouse over the statistics for a description of the component.

Table 51: Right click on the Spotlight home page component for more detail.

Right Click Description

What's This?

Show help on the component.

Icon Help Reference Description

Connection drilldowns

If available, click to show more numerical detail related to the Spotlight home page component.

What's this?

If alarms have been raised against the component then What's This? provides assistance in resolving the alarms.

The behavior of What's This is configurable. For more information, see Home page click action.

Show History

Show the component's history in a popup chart.

Use the chart toolbar to zoom and maximize the view. For more information, see Zoom in on charts.

Right-click the chart to set the time frame.

For more historical views see Playback

Show Details

Show more numerical detail related to the Spotlight home page component. For more information, see Connection drilldowns.

Copy to Clipboard

Copy numeric data associated with the component to the clipboard. For more information, see Copy to clipboard.

Components in an alarm state

If the component's color is other than green then the component is in an alarm state. Click on the component for help to resolve the alarm. For more information, see What's this?.

Note: If Spotlight is unable to collect the data required, Spotlight displays a small icon on the affected component. Click the icon to see more information about the problem.

During a planned outage, all home page controls are disabled except Status. A Monitored Server - Planned Outage alarm is raised against the Status control. For more information, see Configure | Planned Outage.

Home page by connection type

The visual representation of the home page is tailored to the connection type.

Connection Type Description

Analysis Services | Home Page

Spotlight home page for SQL Server Analysis Services connections.

Availability Groups

Home page for an Availability Group. An availability group is a set of user databases that fail over together.


Home page for a Hyper-V server.

SQL Server Replication | Home Page

Spotlight home page for SQL Server Replication connections.

SQL Azure | Home Page

Spotlight home page for SQL Azure connections.

SQL Server | Home Page

Spotlight home page for SQL Server connections.


Home page for a VMware server.

Windows Server | Home Page

Spotlight home page for Windows Server connections.

Spotlight Diagnostic Server

Spotlight home page for Spotlight Diagnostic Server in the deployment.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating