Export (0) Print
Expand All

Databases Created by Service Manager 2010

Updated: December 1, 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

ServiceManager

Configuration Items, Work Items, Incidents

Service Manager data warehouse

DWStagingAndConfig

DWRepository

DWDataMart

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.

ImportantImportant
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 scsmdocs@microsoft.com.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft