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

Guidelines for Creating MS SQL Server Database Objects

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

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 your deployment's requirements.

Use the settings 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. 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 machine, as described in Installing Siebel Enterprise Server and Related Components you can 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.

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

Siebel Installation Guide for Microsoft Windows Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.