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.

See Also

Reference

SCRM 2006 SCRS_ComputerDimension_View
SCRM 2006 SC_CounterDetailDimension_View

Other Resources

SCRM 2006 MOM Views
SCRM 2006 Report Customization
SCRM 2006 SMS Views
SCRM 2006 Stored Procedures