Hi Kevin,
My SAS are either 1.2TB or 600GB.
The SAN has mirrored 146GBs for boot and 4x1.2TB in Raid 5 for Data. But this was predicated by the SAN being stubborn rather than my choice. I don't store VMs on the SAN, its just for backups, ISOs and when using the free version of VMWare it allows me to copy VMs from host to host.
The SSDs are 120GB or 240GB (basically because it was cheaper and i didn't need the storage). The VMs that require fast storage get 2 drives a C drive from the SAS and a D drive from the SSD only the SQL goes onto the D drive.
You are correct VMWare can detect SSD drives and can utilise them for swap space, but this is more important on systems where the VMs are stored on a SAN and the bottleneck is say a 10GBe or 4Gb fibre connection, you don't wanna swap over that. As you are running your VMs on the host drives, which are way faster than a 1, 4 or 10Gb SAN, those SSDs are best setup as drives for SQL. With your RAM you wont or shouldn't be swapping anyway, and if you are swapping buy more RAM.
You have to remember much of the talk about VMWare config is geared toward very large VM counts and a large amount of shared resources, 100 of VMs on a Host, all stored on a SAN. These are very different to config compared to what you and I are doing. We have relatively few VMs and we want serious performance from each of them. I've done some work with Sydney University and my "VMWare" friend is the manager of NSW University Infrastructure, and they have hundreds of lazy, forgotten servers, doing not much, with the VMs stored on the SAN.
VMWare doesn't care what raid you run, as the raid is setup via the PERC before vmware is installed anyway. It works, but maybe the comments you heard where more inline with perhaps a recommended setup, Raid 5 can be slower to write than some other configs, so perhaps someone had a view on that.
I have VMWare Essentials Plus 3 Host Version (retail is about $7k) I got mine from a HP Reseller in Melbourne for $2.25k, much more reasonable!
But, after while with a little VMWare practice you can get a lot done with their free version. My 4th Host will be running the free version.
If you want to place your hosts into a cluster and have VMWare manage fallover for you, you'll need full licences. But some VMs like my Domain Controllers, Backup Devices, General Admin stuff, can sit on the free one anyway. So you can get some serious value out of VMWare without paying a fortune for it.
I almost went down the path of Microsoft HyperV due to VMware's bizarre licencing, but i really love VMware now, makes working with my servers a joy. I don't even need a technician anymore (saving of $70k pa), I do it myself and actually like it.
Regards
Bill