Databases Created by System Center 2012 - Service Manager
Updated: May 13, 2016
Applies To: System Center 2012 SP1 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 - 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
|Service Manager database
|Configuration Items, Work Items, Incidents
|Service Manager data warehouse
|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.
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.