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

Guidelines for Configuring MS SQL Server Parameters

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

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 the component Enterprise Integration Mgr (alias EIM), for Siebel 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. Enable this option.
• auto update statistics. This option 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 MS SQL Server Statistics.

• tempdb. This option specifies 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.