Export (0) Print
Expand All

Databases Created by System Center 2012 - Service Manager

Updated: November 1, 2013

Applies To: System Center 2012 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 SP1 - Service Manager

Before starting the installation of System Center 2012 – Service Manager, you may want to meet with your SQL Server administration team and discuss the impact that Service Manager will have on your computers running SQL Server—specifically, the databases that will be created. The databases that are created by a deployment of Service Manager are listed in the following table.

 

Service Manager parts Database name Contents

Service Manager database

Service Manager

Configuration Items, Work Items, Incidents

Service Manager data warehouse

DWStagingAndConfig

DWRepository

DWDataMart

DWASDataBase

OMDWDataMart

CMDWDataMart

These first three databases make up the data warehouse. The extract process populates the DWStagingAndConfig database, which is transformed into a proper format in the DWRepository database, which, through the load process, becomes the content for the DWDataMart database.

The DWASDatabase is used by SQL Server Analysis Services (SSAS) and stores Microsoft Online Analytical Processing (OLAP) cubes.

The OMDWDataMart and CMDWDataMart databases are for collecting data from Operations Manager and Configuration Manager, respectively.

ImportantImportant
For this release, Service Manager does not support case-sensitive instance names. Setup will display a warning if you attempt to install Service Manager on a case-sensitive instance of Microsoft SQL Server.

-----
For additional resources, see Information and Support for System Center 2012.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
-----
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft