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 |
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. |
Important
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.