Moving the SQL Server Temporary Directory

The SQL Server temporary directory, tempdb, where temporary database objects generated during table creation and sorting are stored, is typically created in the same location on your Orion database server as the master, model, and msdb databases. Moving the tempdb database to a physical drive separate from your Orion database can significantly improve overall system performance.

For more information about moving the SQL Server 2008 temporary directory, tempdb, search MSDN.