none
Data Set

Answers

  • Dataset is a set of tables, stored procedures and corresponding SCOM Write Actions. Dataset should be defined in the Management Pack using DataWarehouseDataSet element. SCOM Datasets are used to store historical monitoring data of certain structure.

    Aggregation is the method where raw data, which is collected on short intervals i.e. 5 minutes, are averaged into hourly and daily time intervals used for reporting purposes. The Operations Database. A stored procedure, called p_PartitioningandGrooming is run by a SCOM rule on a once a day schedule.

    So Hourly aggregation means data averaged in hourly basis and daily means data averaged daily basis. 

    Hope this helps:)


    Cheers, Gourav Please remember to mark the replies as answers if it helped.

    • Proposed as answer by GouravIN Wednesday, June 13, 2018 5:28 AM
    • Marked as answer by SCOM_123 Wednesday, June 13, 2018 11:05 AM
    Wednesday, June 13, 2018 5:28 AM

All replies

  • As far as i know, SCOM operations manager DB has tables
    [State].[StateDaily_CF4EF0B937BA4EC192D480147EAD5E38]:raw data is aggregation daily to calculate daily average value
    [State].[StateHourly_60A46151EFF24FECAD6E7A5B19378BA8]: raw data is aggregation hourly to calculate hourly average value
    [State].[StateRaw_7E27E90D6AD74986AEF313FAE91F7D47]: store performance raw data
    They are store performance data.
    Roger

    Wednesday, June 13, 2018 3:20 AM
  • Dataset is a set of tables, stored procedures and corresponding SCOM Write Actions. Dataset should be defined in the Management Pack using DataWarehouseDataSet element. SCOM Datasets are used to store historical monitoring data of certain structure.

    Aggregation is the method where raw data, which is collected on short intervals i.e. 5 minutes, are averaged into hourly and daily time intervals used for reporting purposes. The Operations Database. A stored procedure, called p_PartitioningandGrooming is run by a SCOM rule on a once a day schedule.

    So Hourly aggregation means data averaged in hourly basis and daily means data averaged daily basis. 

    Hope this helps:)


    Cheers, Gourav Please remember to mark the replies as answers if it helped.

    • Proposed as answer by GouravIN Wednesday, June 13, 2018 5:28 AM
    • Marked as answer by SCOM_123 Wednesday, June 13, 2018 11:05 AM
    Wednesday, June 13, 2018 5:28 AM