SQL Server Storage Engine

Two new white papers by SQL Server Storage Engine Team

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

http://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.

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

 

These papers will soon be available on TechNet as well. 

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

Published Tuesday, June 20, 2006 5:07 PM by Sunil Agarwal

Comments

 

MikeWalsh said:

Thank you very much.. These are both very well needed and well written documents. I only have one question.. I mean this in the best possible way.. I love the content and wouldn't want it any shorter, but... At how many pages does a white papeR become a white book? :-)  

Keep up the excellent work and I look forward to many more white papers and many more excellent posts.
June 20, 2006 8:13 PM
 

xie said:

Read half way through it. Anyone can tell me what's the difference between Figure 2 and Figure 3? How to setup a RAID 10 with 25 disks?

Good work, no doubt of that. Just wondering, if SQL team continue to blog this way, who will need to buy books anymore? :)
June 23, 2006 2:26 PM
 

Sunil Agarwal said:

Comments from the authors (Kathy/Lewis)

>>what's the difference between Figure 2 and Figure 3?

In figure 2, all the filegroups are on one logical drive.  In figure 3, the filegroups are separated out in different logical drives.

>>How to setup a RAID 10 with 25 disks?

You can’t.  This is a mistake.  I will be correcting this to have even number of drives.
June 27, 2006 11:41 AM
 

steveseth said:

Hi Sunil,

I am not able to download the white papers given above. Could you guide me from where i can get the docs for the tempdb and physical storage?

thanks in advance ...

June 22, 2007 12:47 AM
 

Sunil Agarwal said:

I have updated the links. thanks for pointing this out.

June 22, 2007 12:55 PM
Anonymous comments are disabled

About Sunil Agarwal

Sunil Agarwal is a Program Manager in the SQL Server Storage Engine Group at Microsoft. He is responsible for concurrency, indexes, tempdb, LOBS, supportability, and bulk import/export. Prior to joining Microsoft, Sunil worked at DEC, Sybase, BMC Software and DigitalThink, focusing primarily on core database engine technologies and related applications.

This Blog

Syndication

© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Microsoft
Page view tracker