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?