Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

spotlight_timestamps

spotlight_timestamps contains a summary of times for which data was collected, qualified by monitored entity. It allows Spotlight to quickly determine the times for which historical data is available for individual monitored entities, without the overhead of scanning the potentially large fact table spotlight_perfdata. There is one row in this table for each category of data collected.

Column Description

timestamp_id

Generated ID.

timecollected

The time this fact was collected from the monitored object.

domain_id

The domain that this fact belongs to.

monitored_object_id

Generated ID.

statistic_class_id

The collection that this fact came from.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating