Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

Spotlight Statistics Repository

Long term history for reporting and trending is stored in the Spotlight Statistics Repository.

Deployment

The Spotlight Statistics Repository is deployed on SQL Server. For specifications see the Spotlight on SQL Server Enterprise Release Notes.

The Spotlight Statistics Repository is not created during the installation of Spotlight on SQL Server. The Spotlight Statistics Repository is (optionally) enabled in the Spotlight Client for the Spotlight Diagnostic Server following installation of Spotlight.

Many Spotlight Diagnostic Server can connect to one Spotlight Statistics Repository.

Configuration

Use a Spotlight Client to enable, create and .

Maintenance

Backup Spotlight data

The Spotlight Statistics Repository is deployed on SQL Server. The backup procedure is the same as for any other SQL Server database.

Maintenance plan for Spotlight Statistics Repository and Playback Database

It is highly recommended that regular maintenance is performed to maintain efficient data retrieval.

Upgrade

Following upgrade of the Spotlight Diagnostic Server, the Spotlight Statistics Repository is automatically upgraded the next time it is accessed by the Spotlight Diagnostic Server. This may be some time following the upgrade of the Spotlight Diagnostic Server, depending on how often the Spotlight Statistics Repository is accessed.

If in your environment the Spotlight Statistics Repository is replicated as per a Microsoft Replication database the upgrade can fail if schema changes are required that can only be made when replication is turned off. To successfully upgrade the Spotlight Statistics Repository, the steps are to: turn replication off, upgrade the Spotlight Diagnostic Server, then re-enable replication.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating