Siebel Server Installation Guide for Microsoft Windows > Creating the Microsoft SQL Server Database >

MS SQL Server Configuration Guidelines

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

NOTE:  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 in the Microsoft documentation, information provided by your hardware vendor, and other sources. 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 eBusiness Applications documentation. 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 is used to configure Microsoft SQL Server's use of parallel query plan generation. In general, parallel query processing creates competition among resources when multiple simultaneous connections are taking place.

A value of 0 means that every processor on the database server will be considered in generating a parallel query plan. A value of 1 means that only one processor on the database server will be used for a query plan generation. It is recommended that you set this value to 1, turning off parallelism, thereby avoiding parallel query plan generation.

In a multi-user, multi-connection environment, it is recommended that you use one processor for parallel query plan execution. Also, if you use parallel EIM threads with Enterprise Integration Manager (EIM), use one processor for parallel query plan execution because the parallel EIM threads are effectively handling parallel queries. To select one processor for parallel query plan execution, in the SQL Server Properties screen, select the Processor tab, in the Parallelism section, select Use 1 processor.

If you are upgrading to a newer version of the database, set the value to 0 to allow Microsoft SQL Server to use all available CPUs.

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 allows Microsoft SQL Server to automatically manage database statistics and update them as necessary to promote proper query optimization. This option should be enabled.

NOTE:  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 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.

 Siebel Server Installation Guide for Microsoft Windows 
 Published: 25 June 2003