none
Configuration Dataset in DW database

    Question

  • This is more of an informational request. I am doing some in house documentation on our deployment of SCOM 2016 (soon to be 1801) and I am having a hard time finding a good description of the Configuration Dataset in the DW database.  Can anyone help me out?

    Thanks,

    Rene

    Thursday, June 14, 2018 6:46 PM

Answers

  • Dataset name

    Aggregation name

    Purpose

    Alert data set

    Raw data

    Store SCOM Alert raw data

    Client Monitoring data set

    Raw data

    Store SCOM Monitoring raw Data

    Client Monitoring data set

    Daily aggregations

    SCOM monitoring data is aggregated in daily base

    Configuration dataset

    Raw data

    Store SCOM Configuration data such as monitor object, rule and monitor information

    Event data set

    Raw data

    Store SCOM Event Data

    Performance data set

    Raw data

    Store SCOM performance raw Data

    Performance data set

    Hourly aggregations

    SCOM performance data is aggregated in hourly base

    Performance data set

    Daily aggregations

    SCOM performance data is aggregated in daily base

    State data set

    Raw data

    Store SCOM state raw Data

    State data set

    Hourly aggregations

    SCOM state data is aggregated in hourly base

    State data set

    Daily aggregations

    SCOM state data is aggregated in daily base

     

    roger


    • Proposed as answer by Sameer Mhaisekar Friday, June 15, 2018 4:17 AM
    • Marked as answer by rene_paq Friday, June 15, 2018 1:32 PM
    Friday, June 15, 2018 3:42 AM
  • Hi,

    The configuration dataset contains all the discovered properties of all your managed entities, groups, etc.

    Please see the Kevin's comment.

    Understanding and modifying Data Warehouse retention and grooming

    https://blogs.technet.microsoft.com/kevinholman/2010/01/05/understanding-and-modifying-data-warehouse-retention-and-grooming/


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Marked as answer by rene_paq Friday, June 15, 2018 1:32 PM
    Friday, June 15, 2018 9:55 AM
    Moderator

All replies

  • Dataset name

    Aggregation name

    Purpose

    Alert data set

    Raw data

    Store SCOM Alert raw data

    Client Monitoring data set

    Raw data

    Store SCOM Monitoring raw Data

    Client Monitoring data set

    Daily aggregations

    SCOM monitoring data is aggregated in daily base

    Configuration dataset

    Raw data

    Store SCOM Configuration data such as monitor object, rule and monitor information

    Event data set

    Raw data

    Store SCOM Event Data

    Performance data set

    Raw data

    Store SCOM performance raw Data

    Performance data set

    Hourly aggregations

    SCOM performance data is aggregated in hourly base

    Performance data set

    Daily aggregations

    SCOM performance data is aggregated in daily base

    State data set

    Raw data

    Store SCOM state raw Data

    State data set

    Hourly aggregations

    SCOM state data is aggregated in hourly base

    State data set

    Daily aggregations

    SCOM state data is aggregated in daily base

     

    roger


    • Proposed as answer by Sameer Mhaisekar Friday, June 15, 2018 4:17 AM
    • Marked as answer by rene_paq Friday, June 15, 2018 1:32 PM
    Friday, June 15, 2018 3:42 AM
  • Hi,

    The configuration dataset contains all the discovered properties of all your managed entities, groups, etc.

    Please see the Kevin's comment.

    Understanding and modifying Data Warehouse retention and grooming

    https://blogs.technet.microsoft.com/kevinholman/2010/01/05/understanding-and-modifying-data-warehouse-retention-and-grooming/


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Marked as answer by rene_paq Friday, June 15, 2018 1:32 PM
    Friday, June 15, 2018 9:55 AM
    Moderator
  • Thanks for the replies.  All were helpful.

    Rene

    Friday, June 15, 2018 1:32 PM