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

Guidelines for Configuring Microsoft SQL Server Parameters

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

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

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

• max degree of parallelism. This parameter 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 that the query executes on all of the available processors on the database server computer. 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 that 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 the component Enterprise Integration Mgr (alias EIM), for Siebel EIM. Do this even when you are using parallel Siebel EIM threads.

• auto create statistics. This parameter allows SQL Server to create new statistics for database columns as needed to improve query optimization. Enable this option.
• auto update statistics. This parameter allows Microsoft SQL Server to automatically manage database statistics and update them as necessary to promote proper query optimization. Enable this option.

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

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