Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

Query the Spotlight Statistics Repository

Query the Spotlight Statistics Repository

Data is collected from the SQL Server instance then written to the Spotlight Statistics Repository.

Table 99: What you need to know to query the Spotlight Statistics Repository

Section Description
Schema of the Spotlight Statistics Repository Show how the repository is structured and the data it contains.
Data flow into the Spotlight Statistics Repository Collected data is inserted into the relevant dimension tables and the fact is written into the fact table (spotlight_perfdata).
Browse dimension tables and retrieve data Use Spotlight API stored procedures to browse dimension tables in the repository. Then use additional stored procedures or custom T-SQL to retrieve data.

Table 100: Reference to the schema of the Spotlight Statistics Repository

Section Description
Table definitions Definitions to repository objects (tables) created by Spotlight on SQL Server in the Spotlight Statistics Repository.
Stored procedures Definitions to repository objects (procedures) created by Spotlight on SQL Server in the Spotlight Statistics Repository. Stored procedures return metadata about the Spotlight Statistics Repository or data from within the Spotlight Statistics Repository.
Specifications Specifications to the stored procedures in the Spotlight Statistics Repository.

 

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating