Collected data is inserted into the relevant dimension tables and the fact is written into the fact table (spotlight_perfdata).
Edit me

Following is an example of data from the sqlblockinglist collection written to the Spotlight Statistics Repository. The Diagnostic Server DS123 is collecting data about SQL Server instance SQLServer789 running on Windows host Windows01.

How data flows into the Spotlight Statistics Repository
How data flows into the Spotlight Statistics Repository