Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

spotlight_perfdata

spotlight_perdata is the fact table into which all of the data is stored. Each fact is effectively matrixed by the hierarchy of attributes that denote which Spotlight Diagnostic Server, monitored object, collection and collection column the datum originally came from.

Column

Description

perfdata_id

Generated ID.

monitored_object_id

The monitored object that this fact came from.

statistic_class_id

The collection that this fact came from.

statistic_name_id

The column in the collection that this fact came from.

statistic_key_id

The key column of the collection that this fact came from.

timecollected

The time this fact was collected from the monitored object.

raw_value

The raw value returned by the collection for that column.

num_observations

Internal use only.

sum_of_values

Internal use only.

max_value

Internal use only.

min_value

Internal use only.

sum_of_squares

Internal use only.
wide_string

An alternative to raw_value that is used where the width of the data collected is too large for a variant data type. Either wide_string will contain a value or raw_value but never both.

The using_wide_string column in the spotlight_stat_names table shows whether a statistic name is using the wide_string column or not.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating