Upgrade Guide > Preparing an MS SQL Server Database for a Siebel Upgrade >

Setting MS SQL Server Configuration Parameters for a Siebel Upgrade

Upgrades: All Siebel upgrades.

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 MSSQL 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 below.
• After the upgrade, reset the configuration parameters to the values listed in Siebel Installation Guide for the operating system you are using.

Table 27 lists upgrade settings for MS 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.

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.