Two new white papers by SQL Server Storage Engine Team

  • Article

Here is the summary and the link to the white papers.

Working with TempDB

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

https://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx

 

Physical Database Storage

This article provides a guide for physical storage design and gives recommendations and trade-offs for physical hardware design and file architecture.

https://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx

 

These papers will soon be available on TechNet as well. 

https://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbengine.mspx