Disk Partition Alignment - best-kept secret related to SQL Server performance

Briefly,
By default there is no disk partition alignment on
Windows 2003 Server. This cause accessing 2 tracks of
HDD instead of 1 for each & every I/O request!

It happens due to wrong partition start offset value.
In combination with stripe unit size & file allocation unit size,

it is possible to increase the SQL Server I/O throughput
by 10%, 15%, 30% or more.

href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6JEiyxrAhsRC2-lnxondt1Lazj21__uuD-BzAT-f9Vxs-uxKm-T5iYIUrMFKyyhzaI3cRf9YTXypDVKuLEzzfF_Ozq0p-dgS8NjFjmuEG4Pbpz_bvipFNmQikDG5Xw3jUnxHYM0JlOKQ/s1600-h/Disk.JPG">By default there is no disk partition alignment on Disk Partition Alignment - best-kept secret related to SQL Server performance


Check the Jimmy May`s blog,he describes it very good:
http://blogs.msdn.com/jimmymay/archive/2008/10/14/disk-partition-alignment-for-sql-server-slide-deck.aspx


For more information:
http://support.microsoft.com/kb/929491


Disk Partition Alignment Best Practices for SQL Server:
http://msdn.microsoft.com/en-us/library/dd758814.aspx

Related Posts :