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-par...
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,
