Inquiry about Disk Partition Alignment for better performance

40 pts.
Tags:
Disk arrays
Disk partitioning
Hard disk performance
Hi

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?

 

Thank you



Software/Hardware used:
Windows Server 2003 Enterprise, SQL Server 2000 Enterprise
ASKED: January 20, 2010  12:13 PM
UPDATED: January 26, 2010  3:51 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

There is no way to change the offset of a disk after there is data on it. You have to move the data to another volume, then delete the partition, then recreate it using the correct offset. Then copy the data back.

Doing this typically requires a large amount of downtime.

Having office doesn’t impact this at all.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • KansasCoder
    Thanks for your reply! By large amount of downtime does this mean like 6 hours or more? The disks are 1.08 TB, 1.36 TB and 34Gb in TOTAL size with Free Space of 650Gb, 223Gb and 25,8Gb respectively. Is most of the time required for the transfer of the data to the backup disks? Is the reformatting process itself pretty quick? Thank you!
    40 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following