Siebel Database Upgrade Guide > Preparing an Microsoft SQL Server Database for a Siebel Upgrade >
Setting Microsoft SQL Server Temporary Space Size for a Siebel Upgrade
Upgrades from: All Siebel releases. Environments: Development, production test, production. Databases: MS SQL Server only. Platforms: MS 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
- Make
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.
- Execute
dbcc shrinkdatabase against TEMPDB .
|