Disk Partition Alignment Best Practices for SQL Server whitepaper

This paper documents performance for aligned and nonaligned storage and why nonaligned partitions can negatively impact I/O performance; it explains disk partition alignment for storage configured on Windows Server 2003, including analysis, diagnosis, and remediation; and it describes how Windows Server 2008 attempts to remedy challenges related to partition alignment for new partitions yet does not correct the configuration of preexisting partitions.



Published Tuesday, May 12, 2009 4:44 PM by sqldbatips


No Comments