About the Book

Senior DBAs have to know more than just SQL Server - they have to know storage, memory, operating systems, and more. This book gathers everything you need to know in one place, and each chapter is written by a SQL Server expert with extensive experience.

You'll learn about topics like latching, locking, memory architecture, extended events, and more.

Chapter 4 - Storage

Author: Brent Ozar

This chapter covers the types of storage, storage performance testing, and configuring Windows & SQL Server 2008 for storage.

Errata

Figure 4-6 should only have five data drives in the RAID 5 array, and one parity drive. Brian Kelley (Blog – @KBrianKelley) found this.

Downloads

None yet.  If there’s anything you’d like to see added here, let us know with a comment.

2 comments to Chapter 4 – Storage

  • zhengsyao
    April 11, 2010 at 5:49 am

    on page 104, why a 10-terabyte RAID 10 configuration will outperform a 10-terabyte RAID 5 configuration?

    10TB RAID 10 configuration has only 5 TB usable capacity, while 10TB RAID 5 configuration has 9TB usable capacity.

  • Brent Ozar
    April 12, 2010 at 2:04 pm

    Great question. If you read the full sentence, I note that I’m talking about arrays with a 10-terabyte usable capacity. A 10TB array of RAID 10 will cost more than the same usable capacity of RAID 5, but it will perform better because there’s more drives involved (among other things).

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="">