Chat now with support
Chat with Support

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


Open this screen from the Spotlight Client

  1. Click Configure | Diagnostic server.

  2. Select Configure the Spotlight Statistics Repository.

Select the Diagnostic Server

For federated Spotlight Diagnostic Server () you will be prompted to select the Spotlight Diagnostic Server to configure. Each Spotlight Diagnostic Server is independently configured for the Spotlight Statistics Repository.

Configure the Spotlight Statistics repository

Option Description

Enable use of the Spotlight Statistics Repository

Select to store data in the Spotlight Statistics Repository. Clear to stop storing (not store) data in the Spotlight Statistics Repository.


The name of the SQL Server instance to host the Spotlight Statistics Repository. Click the down arrow to list available instances.

Note: Due to the size of the Spotlight Statistics Repository, it is recommended that this database is not installed on a SQL Express instance. The Spotlight Statistics Repository is not supported on High Availability Always On and mirrored databases. The Spotlight Statistics Repository cannot be installed on SQL Server 2000.


The authentication for Spotlight to use to connect to the Spotlight Statistics Repository.

Select Windows Authentication (using Diagnostic Server credentials) to use the account that runs the . Ensure this account is trusted by the SQL Server.

Alternatively, select SQL Server authentication and fill in the User and Password fields. The SQL Server user must have sufficient privileges to connect to the SQL Server instance hosting the Spotlight Statistics Repository.


The name of the Spotlight Statistics Repository.


Click Create to create a new Spotlight Statistics Repository. For more information, see Create Spotlight Statistics Repository dialog.

Store alarms in the repository for … days

The number of days to store alarm data in the repository, by default 30.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating