Setting Microsoft SQL Server Temporary Space Size for a Siebel Upgrade

Environments: Development, Test and Production.

Databases: MS SQL Server only.

Platforms: Windows only.

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 Microsoft 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.