Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

Data flow into the Spotlight Statistics Repository

Data is collected from the SQL Server instance by the Spotlight Diagnostic Server then written to the Spotlight Statistics Repository. The data is inserted into the relevant dimension tables and the fact is written into the fact table (spotlight_perfdata).

Let’s use the example of data from the sqlblockinglist collection written to the Spotlight Statistics Repository. In the following chart, the Diagnostic Server, DS123, is collecting data about SQL Server instance, SQLServer789, running on Windows host, Windows01.

Figure 5: How data flows into the Spotlight Statistics Repository

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating