We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Partition alignment offset and Allocation unit size in Windows 2003 Server system with SQL 2005 DB

Medium Priority
1,229 Views
Last Modified: 2012-05-07
Hi,

I've a couple of Windows 2003 servers with SQL 2005 DB installed and I plan to install some new ones. They are all VMware virtual machines and they have usually 3 partitions: C: with system, D: with SQL database and E: with some installation files. I've searched in google that to get better performance of system and DB I should customize partition(s) allignment offset.

A couple of advices I could find in this article: https://www.experts-exchange.com/Storage/Misc/Q_23977512.html?sfQueryTermInfo=1+64+align+offset

So... I've made use of Dell's advice and fixed allocation unit size for partition on which SQL DB resides to 64K. Partition's alignment offset has been set to 64K as well. My questions are:

- Should I also setup the same offset for C: partition (where system resides)? What about allocation unit size for C partition?
- Does somebody have a link to webpage where partition alignment, offsets and all this stuff is described in a pretty simple way?

Regards.
Comment
Watch Question

Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.