Share via

Databases Created by Service Manager 2010

Applies To: System Center Service Manager 2010 SP1

Before starting the installation of Service Manager, you might want to meet with your SQL Server Administration team and discuss the impact Service Manager will have on your SQL Servers, specifically the databases that will be created. Databases that are created are listed in the following table:

Service Manager Parts DB Name Contents

Service Manager database


Configuration Items, Work Items, Incidents

Service Manager data warehouse




These three databases comprise 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.


For this release, Service Manager does not support case-sensitive instances. Setup will fail if you attempt to install Service Manager on a case-sensitive SQL instance.

Did you find this information helpful? Please send your suggestions and comments about System Center Service Manager documentation to