Configure the Playback Database

Recent events and data collected in the recent past are stored in the Playback Database.

Configure the Playback Database from the Spotlight Client

Click Configure | Diagnostic server.
Select Configure the Playback Database.

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 has an independently configured Playback Database.

Store playback data for n days

Specify the number of days to store data in the Playback Database. The number of days corresponds to the number of days of history available to Playback. The default is seven days. The minimum is two days.

Instance

Specify the name of the SQL Server instance or Azure SQL Managed 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.

Azure SQL Managed Instance Connection

Select Azure SQL Managed Instance Connection checkbox to display valid authentication types available for selected connection.

Authentication

Specify 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. Windows Authentication is not applicable for Azure SQL Managed 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 or Azure SQL Managed instance hosting the Playback Database.

Database

Specify 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.