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 |
---|---|---|---|
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. |
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