Database Reference
In-Depth Information
There's more...
It is important to understand the schema for the System Center components, but equally
important are the processes that populate the databases. The data population process differs
by component, but the results are the same (data is automatically inserted into the respect-
ive reporting database). The schema is a map to find the data, but the information available
is provided by the agents and processes that transfer the information into the databases.
Components with multiple databases
System Center Service Manager and Operations Manager have a similar architecture. The
data is initially written to the operational database and then transferred to the data ware-
house. The operational database information is typically what is available to view in the
console. The operational information is, however, not the best candidate for reporting, as
this is constantly changing. Additionally, performing queries against the operational data-
base can result in performance issues. You may view the schema of these databases using a
process similar to the one described earlier, but this is not recommended for reporting pur-
poses.
