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