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.

http://msdn.microsoft.com/en-us/library/dd758814.aspx

 

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

Comments

No Comments