SQL Server & Disk Partition Alignment

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


%3CLINGO-SUB%20id%3D%22lingo-sub-383492%22%20slang%3D%22en-US%22%3ESQL%20Server%20%26amp%3B%20Disk%20Partition%20Alignment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-383492%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Nov%2005%2C%202008%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EJimmy%20May%20is%20sharing%20a%20very%20good%26nbsp%3Bslide-deck%20about%20the%20importance%20of%20Disk%20Partition%20Alignment.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fblogs.msdn.com%2Face_team%2Farchive%2F2008%2F11%2F04%2Fdisk-partition-alignment-sector-alignment-part-i-slide-deck.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.msdn.com%2Face_team%2Farchive%2F2008%2F11%2F04%2Fdisk-partition-alignment-sector-alignment-part-i-slide-deck.aspx%20%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EYou%20can%20find%20some%20other%20useful%20information%20about%20this%20topic%20on%20the%20Microsoft%20web%20site%3A%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%C2%B7%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Predeployment%20I%2FO%20Best%20Practices%20-%20SQL%20Server%20Best%20Practices%20Article%20%3CBR%20%2F%3E%20%3CA%20href%3D%22http%3A%2F%2Fwww.microsoft.com%2Ftechnet%2Fprodtechnol%2Fsql%2Fbestpractice%2Fpdpliobp.mspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fwww.microsoft.com%2Ftechnet%2Fprodtechnol%2Fsql%2Fbestpractice%2Fpdpliobp.mspx%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%C2%B7%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Disk%20Subsystem%20Performance%20Analysis%20for%20Windows%20subsys_perf.doc%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fwww.microsoft.com%2Fwhdc%2Fdevice%2Fstorage%2Fsubsys_perf.mspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fwww.microsoft.com%2Fwhdc%2Fdevice%2Fstorage%2Fsubsys_perf.mspx%20%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%C2%B7%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Disk%20performance%20may%20be%20slower%20than%20expected%20when%20you%20use%20multiple%20disks%20in%20Windows%20Server%202003%2C%20in%20Windows%20XP%2C%20and%20in%20Windows%202000%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F929491%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F929491%20%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3ECheers%2C%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-383492%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Nov%2005%2C%202008%20Jimmy%20May%20is%20sharing%20a%20very%20good%26nbsp%3Bslide-deck%20about%20the%20importance%20of%20Disk%20Partition%20Alignment.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-383492%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerTiger%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Mar 23 2019 11:05 AM
Updated by: