Data Warehouse

The Data Warehouse (often abbreviated DW or OMDW) is a core component of the SCOM architecture used to store all the historical data of the Management Group.

Description
The Data Warehouse is hosted on a SQL Server Database instance. It is accessed by the Management Servers of a SCOM platform to write and store the data.

They are used to generate reports of the health and performance of monitored objects.

Structure
The number of tables in the database can attain a large number (around one hundred or more). The table are organized automatically to store data depending on the aggregation.

Considerations
Considering the amount of data collected by SCOM in the organization environment, it is common to find Data Warehouse reaching size of hundreds gigabytes and even terabytes. Due to the solution functioning, a large Data Warehouse would slow the reporting performance. But unlike the Operational Database, this would not have a strong impact on the health of the SCOM platform overall.

The Data Warehouse size can be modified by modifying the data set retention period. This procedure can not be performed in the Operations Console like it is the case for the Operational Database. A CLI tool called dwdatarp.exe can be used to modify those settings.