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

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

Set the size of the database that MS 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.