SQL Server & Disk Partition Alignment

  • Article

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

https://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
https://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx

· Disk Subsystem Performance Analysis for Windows subsys_perf.doc

https://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

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

Cheers,