re: SQL Server - Speed up your Disks!

aspiringgeek — Thu, 16 Oct 2008 01:25:00 GMT

I'm thrilled you enjoyed my disk partition alignment presentation!

I've updated the deck recently & posted it here:

http://blogs.msdn.com/jimmymay/archive/2008/10/14/disk-partition-alignment-for-sql-server-slide-deck.aspx

It includes the following details:

1. Performance for aligned and non-aligned storage

2. Why non-aligned partitions can be a severe bottleneck

3. Disk partition alignment for storage configured on Windows Server 2003, including analysis, diagnosis, & remediation

4. Describes how Windows Server 2008 attempts to remedy challenges related to partition alignment for new partitions yet does not correct the configuration of pre-existing partitions

5. Background information

6. Implementation

7. Vendor considerations

8. Two essential correlations

9. Valid starting partition offsets

10. The simple protocol to align partitions, define file allocation unit size, & assign drive letters

Let me know if you have any questions.

Jimmy May

Whitepaper - Disk Partition Alignment Best Practices for SQL Server

There's Something about SQL! — Wed, 20 May 2009 10:11:18 GMT

I've blogged some time ago about Microsoft recommendations for maximizing the performances of your disks