Disk Partition Alignment (Sector Alignment): Part I: Slide Deck

Disk partition alignment is a best practice.  Now that SQL Server wait stats are formally documented & DMVs are available, disk partition alignment may be the best-kept secret related to SQL Server performance optimization.   In combination with stripe unit size & file allocation unit size, you can increase I/O throughput by 10%, 30%, or…

1