Siebel Database Upgrade Guide > Preparing a Microsoft SQL Server Database for a Siebel Upgrade >

Setting Microsoft SQL Server Configuration Parameters for a Siebel Upgrade

Upgrades from: All Supported Siebel releases.

Environments: Development, production test, production.

Databases: MS SQL Server only.

Platforms: Windows only.

This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.

This topic provides upgrade-specific settings for the Microsoft SQL RDBMS. Use the following strategy to set parameters:

  • Set parameters using the recommendations in Siebel Installation Guide for the operating system you are using. Recommendations are located in the chapter on configuring the RDBMS.
  • For the upgrade, revise the configuration parameters listed in Table 26.
  • After the upgrade, reset the configuration parameters to the values listed in Siebel Installation Guide for the operating system you are using.

Table 26 lists upgrade settings for Microsoft SQL Server database parameters. For parameters not listed in this table, it is recommended that you accept the default settings.

Most of the parameter settings in the table are the default settings.

Table 26. Microsoft SQL Configuration Parameters

Max. degree of parallelism


Cost threshold for parallelism


Fill factor (%)


Index create memory (KB)


For the Siebel Database, set the following options to ON (enabled) for the upgrade:

  • truncate log on chkpt. Set this option to ON (enabled) for upgrade only. Also, for upgrade only, execute the alter command against the Siebel Database, specifying set recovery simple.
  • torn page detection.
  • auto create statistics.
  • auto update statistics.
  • Database size. Increase your database file size by resetting the Autogrowth parameter to between 25% and 50%. Failure to do this could diminish upgrade performance and possibly impact the success of your upgrade.
  • For a full list of recommended settings for your postupgrade production environment, see the chapter on configuring the RDBMS in Siebel Installation Guide for the operating system you are using.
Siebel Database Upgrade Guide Copyright © 2008, Oracle. All rights reserved.