Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools > Configuring the RDBMS > Configuring MS SQL Server for Siebel Applications >

Guidelines for Creating MS SQL Server Database Objects

To help you automate creation of the Siebel Database schema, Siebel Systems provides sample scripts (CrBlankMSSQLSiebelDEMO.sql and CrBlankMSSQLSiebelDEMO.bat), located in the SIEBEL_ROOT\dbsrvr\MSSQL directory. Use these scripts as a reference to create scripts based on your deployment's requirements for creating database objects for the Siebel schema.

Before using these scripts, make sure you read the file CrBlankMSSQLSiebelDEMOReadMe.txt. See also Overview of Database Configuration.

Use a small, nonproduction environment for testing purposes.

After you install the Siebel Database Server files on the Siebel Server machine, as described in Installing the Siebel Database Server and Configuring the Siebel Database you may modify the database table and index creation scripts to specify the table space names you created for Siebel tables and indexes. For more information, see Guidelines for Overriding MS SQL Server Default Table Spaces for Database Objects.

These settings should be used only as guidelines for your initial configuration. Your final settings will vary based on the server hardware configuration, the number of users, and the type of workload.

Additional information on Microsoft SQL Server configuration is available from Microsoft, the hardware vendor, and other sources of documentation. Also refer to Microsoft documentation for additional information concerning tuning options for Microsoft SQL Server.