Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools > Guidelines for Configuring the RDBMS >

Configuring MS SQL Server for Siebel Applications

This section contains guidelines for obtaining optimal performance from the Microsoft SQL Server database for use with Siebel eBusiness Applications.

To help you automate database instance creation, 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 to create database objects. Prior to using these scripts, make sure you read the CrBlankMSSQLSiebelDEMOReadMe.txt.

Use a small, nonproduction environment for testing purposes.

After you install the Siebel Database Server files on the Siebel Server machine (described in the MS SQL Server sections in Installing the Siebel Database Server), you may modify the database table and index creation scripts as described in the following section.

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 the configuration of Microsoft SQL Server is available from Microsoft, the hardware vendor, and other sources of documentation. You should also refer to the Microsoft documentation for additional information concerning tuning options for Microsoft SQL Server.

CAUTION:  Never make changes to your Siebel Database schema unless instructed on how to do so for a specific purpose by Siebel documentation or Siebel Engineering. Otherwise, you may corrupt your entire system and thereby render it unsupportable.

Guidelines for setting the Microsoft SQL Server parameters for maximum performance follow. For more information, see your Microsoft SQL Server technical documentation.

Review the descriptions of the following parameters and reset as appropriate to your deployment.

max degree of parallelism. This option specifies whether query plans are generated for parallel execution on multiple processors or for execution on a single processor.

• A value of 0 means that each query plan is generated so the query executes on all available processors on the database server machine. In general, parallel query execution is not recommended, because of its effect on scalability.
• A value of 1 means that each query plan is generated so the query executes on only one processor. In other words, this value turns off parallelism for query execution. Using one processor for query execution is recommended. For this option, in the SQL Server Properties screen select the Processor tab, and in the Parallelism section select Use 1 processor.

Also use a single processor for query execution for Siebel Enterprise Integration Manager (EIM)—even when you are using parallel EIM threads.

auto create statistics. This option allows SQL Server to create new statistics for database columns as needed to improve query optimization. This option should be enabled.

auto update statistics. This option allows Microsoft SQL Server to automatically manage database statistics and update them as necessary to promote proper query optimization. This option should be enabled.

Turn both auto create statistics and auto update statistics off when running concurrent EIM threads and performing a full scan of your tables. For information about running full scans, see Updating MS SQL Server Statistics.

tempdb. This is the database that Microsoft SQL Server uses for temporary space needed during execution of various queries. Set the initial size of your TEMPDB to a minimum of 100 MB, and configure it to allow auto-growth to allow SQL Server to expand the temporary database as needed to accommodate your activity.