SQL Server & Disk Partition Alignment

First published on MSDN on Nov 05, 2008

Jimmy May is sharing a very good slide-deck about the importance of Disk Partition Alignment.

http://blogs.msdn.com/ace_team/archive/2008/11/04/disk-partition-alignment-sector-alignment-part-i-slide-deck.aspx

You can find some other useful information about this topic on the Microsoft web site:

·         Predeployment I/O Best Practices - SQL Server Best Practices Article
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx

·         Disk Subsystem Performance Analysis for Windows subsys_perf.doc

http://www.microsoft.com/whdc/device/storage/subsys_perf.mspx

·         Disk performance may be slower than expected when you use multiple disks in Windows Server 2003, in Windows XP, and in Windows 2000

http://support.microsoft.com/kb/929491

Cheers,