itsolution,
Thanks for the helpful answer points. I wrote a blog post about this whole thing that I hope will help:
Partition Alignment and block size VMware 5 | blog.jgriffiths.org
To answer your questions here goes:
I have 1 TB of space (round about) and create two Virutal Drives.
Virtual Drive 1 - 10GB - To be used for Hyper-visor OS files
Virtual Drive 2 - 990GB - Used for VMFS Datastore/VM Storage
The default stripe element size on the Perc6/i is 64KB, but can be 8,16,32,64,128,256,512,or 1024KB.
What block size would you use on Array 1 which is where the actual hyper-visor will be installed?
->If you have two arrays I would set the block size on the hypervisor array to 8KB
What block size would you use on Array 2 which will be used as the VM Datastore in ESXi?
->I would go with 1024KB to match VMFS 5 size
-Would you use 1024KB to make it match the VMFS block size that will eventually be formatted on top of it?
->Yes
*Consider that this data store would eventually store several virtual hard drives for OS, SQL Database, SQL Logs each formatted in NTFS at the recommended block size,4K,8K,64K.
->The problem here is VMFS is going to go with 1MB no matter what you do so carving it lower on the RAID will not cause issues but will not help them either. You have 4KB on sectors on disk. 1MB RAID, 1MB VMFS, 4k,8K,64K Guests. Really the gains from 64K are lost a little when the backend storage is 1MB.
If the RAID Strip element size is set to 1024KB so it matches the VMFS 1MB Block size, would that be best practice or is it indifferent?
->As long as it's 1024KB or smaller in 4KB chucks it does not matter really.
What effect does that have on the OS/Virtual HD's and their respective block sizes installed on top of the stripe element and VMFS block size?
->The effect is minimal on performance but does exist. It would be lie to say it didn't.
I could be completely over thinking the entire situation, but to me it seems that has to be some sort of correlation between the three different "layers" as I call, and a best practice to suit.
Hope that helps. I will tell you have I run SQL and Exchange both virtualized without any issues and without changing the OS block size. I just stuck with the microsoft standard size. I would be a lot more concerned about the performance of the raid controller on your server. They keep making those things cheaper and cheaper with less and less cache. If performance is the major concern then I would consider an array or RAID5/6 solution or at least look at the cache amount on your raid controller (read is normally critical for database)
Just my two cents.
Let me know if you have additional questions.
Thanks,
J