Sunday, January 13, 2008

Working with tempdb in SQL Server 2005

Working with tempdb in SQL Server 2005 (Technet Article)
SQL Server Technical Article, Applies To: SQL Server 2005


Summary: This white paper describes how SQL Server 2005 uses tempdb. Many improvements in SQL Server 2005 optimize tempdb usage and make it easier to manage and to troubleshoot. A case study that uses a workload similar to TPC Benchmark H (TPC-H) shows new ways to manage and troubleshoot tempdb resources. This paper also includes items to consider when upgrading to SQL Server 2005 and configuring tempdb.
WorkingWithTempDB.doc 327 KB, Microsoft Word file

No comments: