Two new white papers by SQL Server Storage Engine Team

Two new white papers by SQL Server Storage Engine Team

Rate This
  • Comments 5

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

Leave a Comment
  • Please add 3 and 7 and type the answer here:
  • Post
  • 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.
  • 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? :)
  • 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.
  • 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 ...

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

Page 1 of 1 (5 items)