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

Setting Microsoft SQL Server Temporary Space Size 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.

Set the size of the database that Microsoft SQL Server uses for temporary space needed to execute queries.

To setup TEMPDB space

  1. Make TEMPDB as big as the biggest table in the Siebel Database, or half the size of the Siebel Database.
  2. Make sure that the files used by TEMPDB are configured to allow auto-growth.

    This allows SQL Server to expand the temporary database as needed to accommodate upgrade activity. Alternatively, you can set MAXSIZE to the size of the biggest table or to 50% of the size of the Siebel Database.

  3. Consider putting TEMPDB on a separate drive to improve performance.
  4. Execute dbcc shrinkdatabase against TEMPDB.
Siebel Database Upgrade Guide Copyright © 2008, Oracle. All rights reserved.