· The root management server, which is the first management server created in a management group, is the focal point for administering the management group and communicating with the database. When you open the Operations console and connect to a management group, you connect to the root management server for that management group.
· The Operations Manager database is a SQL database that contains all configuration data for the management group and stores all monitoring data that is collected and processed for the management group.
· The Data Warehouse database is a SQL database that stores monitoring and alerting data for historical purposes. Data that is written to the Operations Manager database is also written to the Data Warehouse database, so reports always contain current data.
· The Reporting server builds and presents reports from data in the Data Warehouse database.
Carsten Siemens edited Revision 1. Comment: Added tags: en-US, has comment
Fernando Lugão Veltem edited Original. Comment: added tags
Thanks Jeaine
just to be more sure about "Data that is written to the Operations Manager database is also written to the Data Warehouse database", are all data written to OPsDB also exist in DW DB but aggregated? or there's some differences depending on rules?
No, Adam - there is no automatic guarantee of all. The OM db > DW Db flow is not a classic extract and transform. Instead, each management pack author chooses what goes to DW independently of what goes to the ops DB. This choice can be made down to the individual rule/monitor basis today.
Data in 6 dimensions in the DW will automatically be aggregated and eventually groomed from the detail tables on a faster cadence than the aggregates.