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
TEMPDB as big as the biggest table in the Siebel Database, or half the size of the Siebel Database.
- 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.
- Consider putting
TEMPDB on a separate drive to improve performance.
dbcc shrinkdatabase against