SCRM 2006 SC_SampledNumericDataFact_View

SC_SampledNumericDataFact_View lists performance counter data that has been collected by MOM performance rules.

SC_SampledNumericDataFact_View

Column	Type	Constraint	Description
Computer_FK	bigint	Not Null	The computer where the performance counter value was sampled.
ConfigurationGroup_FK	bigint	Not Null	The management group where the performance counter value was sampled.
CounterDetail_FK	bigint	Not Null	Represents the performance counter details for this sample.
DateSampled_FK	bigint	Not Null	The date the performance counter value was sampled.
DateTimeAdded	datetime	Not Null	The date and time when sampling of the performance counter was started.
DateTimeSampled	datetime	Not Null	The date and time the performance counter value was sampled.
LocalDateSampled_FK	bigint	Not Null	The date the performance counter value was sampled. This value includes the database server's local date and time offset.
LocalDateTimeSampled	datetime	Not Null	The date and time the performance counter value was sampled. This value includes the database server's local date and time offset.
LocalTimeSampled_FK	bigint	Not Null	The time the performance counter value was sampled. This value includes the database server's local date and time offset.
SampleValue	float	Not Null	The numeric value of the sampled performance counter.
SMC_InstanceID	bigint	Not Null	The surrogate key for this item.
TimeSampled_FK	bigint	Not Null	The time the performance counter value was sampled.