Chat now with support
Chat with Support

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

Spotlight Diagnostic Server

The Spotlight Diagnostic Server is at the core of the Spotlight on SQL Server architecture. All Spotlight data passes through the Spotlight Diagnostic Server.


The Spotlight Diagnostic Server is a Windows service.

The Spotlight Diagnostic Server is installed by the Spotlight installer.

Most deployments of Spotlight have one Spotlight Diagnostic Server, however a deployment may consist of multiple Spotlight Diagnostic Server or a federation of Spotlight Diagnostic Server if the organization requires Spotlight to monitor more connections than a single Spotlight Diagnostic Server allows or the organization has setup geographic hubs.


View data and configure Spotlight

Configure the Spotlight Diagnostic Server from Spotlight Clients.

Playback Database

Recent historical data is stored in the playback database. Each Spotlight Diagnostic Server requires its own Playback Database.

Spotlight Statistics Repository

Enabling of the Spotlight Statistics Repository is optional. Many Spotlight Diagnostic Server can connect to the same Spotlight Statistics Repository.

Monitored connections in the deployment

The Spotlight Diagnostic Server collects data from SQL Server, Windows and other supported connection types monitored by Spotlight.

A single Spotlight Diagnostic Server is designed to monitor a maximum of 100 SQL Servers, Analysis Services or Replication instances and 100 Windows servers. Exceeding this recommended limit on 32 bit environments may result in poor performance or product instability, due to the 1 Gb memory limit. On 64 bit environments theoretically more connections can be monitored as the 1 Gb limit no longer applies, however testing of this has been limited.

Deployment over the Windows network

A Spotlight on SQL Server deployment consists of many components that may be spread over a wide network. Spotlight's ability to function, to collect and display data, may depend on account permissions granted over the network and specific open network ports.

Spotlight services requiring Internet access

The Spotlight Diagnostic Server requires access to the Internet when enabling Auto Update or Spotlight Cloud services.

Account permissions

The Windows account that the Spotlight Diagnostic Server runs under could be a domain user account or the local system account. These credentials can be used to authenticate Spotlight connections to monitor SQL Server instances and Windows Server, and to connect the Spotlight Diagnostic Server to the Playback Database and Spotlight Statistics Repository.


Backup Spotlight data

Spotlight configuration data is stored in the conf folder on the Spotlight Diagnostic Server. You can perform backups of the Spotlight configuration data by backing up this folder regularly.

Start and stop the Spotlight Diagnostic Server

The Spotlight Diagnostic Server is a Windows service and can be started and stopped via the Windows Control Panel.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating