SQL Server Performance

Disk Alignment

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by pdevadiga, Sep 26, 2009.

  1. pdevadiga New Member

    Hi,This is about Disk Alignment for SQL Server.....does anyone have an idea as to how to implement this.There is a whitepaper called "Disk Partition Alignment Best Practices for SQL Server" by Jimmy May & Denny Lee. Its worth a read but I couldn't get anywhere near.It says this is a default feature in Windows 2008 but still needs to be looked into.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.Can anyone throw light on this subject & if implemented how to go about it? Perhaps a write up or steps to go about it on Windows 2003 would be appreciatedRegards,Prashant
  2. satya Moderator

    It seems you have taken up the document into depths, so I would suggest you to contact them directly for good reference. As I can ensure Jimmy May is really good to respond to emails and clarify any doubts you may have.

Share This Page