Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

Data collection and storage

Table 63: Components of Spotlight that collect and store data

Description

The Spotlight Diagnostic Server is at the core of the Spotlight on SQL Server architecture. All Spotlight data passes through the Spotlight Diagnostic Server. The Spotlight Diagnostic Server is a Windows service. It runs under Windows credentials.

Recent history is stored in the Playback Database. The Playback Database is deployed on SQL Server. There is one Playback Database per Spotlight Diagnostic Server.

Long term history for reporting and trending is stored in the Spotlight Statistics Repository. The Spotlight Statistics Repository is deployed on SQL Server. Deployment of the Spotlight Statistics Repository is optional per Spotlight Diagnostic Server.

Upload health performance data to the Spotlight Cloud. Deployment is optional per Spotlight Diagnostic Server.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating