Spotlight on SQL Server 10.0.3 - Getting Started Guide

Configure the Spotlight Statistics Repository

Note: This feature is available only in Spotlight on SQL Server Enterprise.

Spotlight uses a repository to store data archived from the Spotlight Diagnostic Server. See Requirements for more information on the disk space requirements of the Spotlight Statistics Repository.

You can reduce the size of the repository by:

• Limiting the number of collections archived
• Reducing how often data is collected
• Reducing the data retention period.

See "Schedule Data Collection" in the online help for information on the options that affect the size of the repository.

You can install a new repository on any machine that has a SQL Server 2005 instance or later running, or select an existing data repository for the Spotlight Diagnostic Server to use.

To configure the Spotlight Statistics repository

1. Click Configure | Diagnostic Server.

   

2. Select Configure the Spotlight Statistics Repository.

3. Complete the following options:

   Option	Description
   Enable use of the Spotlight Statistics Repository	When this option is selected, Spotlight stores data in the Spotlight Statistics Repository for reporting purposes. Clear this option to stop storing data in the Spotlight Statistics Repository. This option must be selected to use Spotlight Reporting and Trending.
   Instance	Type or select the name of a SQL Server to host the Spotlight Statistics repository. Clicking the down arrow displays a list of available instances.
   Windows authentication	Select this option to connect to the repository using the Windows user name and password of the user logged in to the Spotlight client.
   SQL Server authentication	Select this option to connect to the repository using SQL Server credentials. Complete the User and Password fields. User – A valid user that enables Spotlight to connect to the instance hosting the Spotlight Statistics Repository. Password – The password required to connect the specified user to the instance hosting the Spotlight Statistics Repository.
   Database	Type the name of the database you are using as the Spotlight Statistics Repository.
   Create	To create a new Spotlight Statistics Repository, type a name in the Database field and then click Create. To change the default name of the repository database or the location of the corresponding data and log files, click Configure repository data and log files. By default, the repository and data log files are created in the same location as those of the model database.