I read that disk partition alignments should have an offset of 64k rather than the default 32k for better sql server performance. Can you tell me more about the requirements for implementing this change?
For instance, can this be done after the disks have been inproduction for some time without the risk of losing data? Are there any situations when this change should never be made or when it could be risky to make such a change? What are the implications of this change on a sql server box that also has some Office products installed on it?
Windows Server 2003 Enterprise, SQL Server 2000 Enterprise
January 20, 2010 12:13 PM
January 26, 2010 3:51 PM