SQL Server & Disk Partition Alignment

Published Mar 23 2019 11:05 AM 458 Views
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,


Version history
Last update:
‎Mar 23 2019 11:05 AM
Updated by: