Chat now with support
Chat with Support

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

Configure the Playback Database

The Spotlight Diagnostic Server stores events and data collected in the recent past in the Playback Database.

Open this screen from the Spotlight Client

  1. Click Configure | Diagnostic server.

  2. Select Configure the Playback Database.

Select the Diagnostic Server

For federated Spotlight Diagnostic Server (Federate Diagnostic Servers) you will be prompted to select the Spotlight Diagnostic Server to configure. Each Spotlight Diagnostic Server has its own Playback Database.

Configure the Playback Database

Option Description

Store playback data for n days

Data will be stored in the Playback Database for the specified number of days. The number of days specified corresponds to the number of days of history available to Playback. The default is seven days. The minimum is two days.

Instance

The name of the SQL Server instance to host the playback database. Click the down arrow to list available instances.

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

Authentication

The authentication for Spotlight to use to connect to the Playback Database.

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

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 Playback Database.

Database

The name of the Playback Database. By default the name is SpotlightPlaybackDatabase.

Create

Click Create to create a new Playback Database. For more information, see Create Playback Database dialog.

TIP: If you want your Playback Database to have a different name to the default, type a new name in the Database field before you click the Create button.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating