次の方法で共有

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

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

Comments

  • Anonymous
    June 20, 2006
    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.

  • Anonymous
    June 23, 2006
    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? :)

  • Anonymous
    June 27, 2006
    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.

  • Anonymous
    June 21, 2007
    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 ...

  • Anonymous
    June 22, 2007
    I have updated the links. thanks for pointing this out.