Siebel Installation Guide for Microsoft Windows > Configuring the RDBMS > Configuring a Microsoft SQL Server Database for Siebel Business Applications >

Guidelines for Creating Microsoft SQL Server Database Objects

Siebel Business Applications provide sample scripts (CrBlankMSSQLSiebelDEMO.sql and CrBlankMSSQLSiebelDEMO.bat), located in the DBSRVR_ROOT\MSSQL directory. Use these scripts as a reference to help you create your own scripts for creating a blank Siebel database based on the requirements for your deployment.

Use the settings in the script as guidelines for your initial configuration. Your final settings will vary depending on the server hardware configuration, the number of users, and the type of workload. Use a small, nonproduction environment for testing purposes.

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

After you install the Database Configuration Utilities on the Siebel Server computer, as described in Installing Siebel Enterprise Server Components and the Siebel Web Server Extension you can modify the database table and index creation scripts to specify the tablespace names that you created for Siebel tables and indexes. For more information, see Guidelines for Overriding Microsoft SQL Server Default Tablespaces for Database Objects.

Additional information about Microsoft SQL Server configuration and tuning options is available from Microsoft, your hardware vendor, and other sources.

This topic is part of Configuring a Microsoft SQL Server Database for Siebel Business Applications.