I would like advice on the best option for setting up drives in my virtual environment. I am running VMware 5.1 and the SQL 2012 server will deployed as a virtual machine. I have a Equalogic PS6100XV SAN with 22 15k hard drives configured in Raid 50.
I understand for best performance you would ideally place SQL logs and data files on different drive spindles which is not really an option considering the Equalogic has a single Raid 50.
Considering this setup, would it still make since to create a separate virtual disks for the logs and data files Ex: (C: system, D: logs, E: data)? Should I create the disks in the same Eqaulogic Volume/Lun or would there be a benefit in creating new Equalogic volumes to hold the log and data files? Lastly, I primary use VMware thin provisioning for disks. Should I consider Thick provisioning for the logs and data file disks? Lazy or Eager Zeroed?
Thanks in advance!