We are running vSphere ESXi 4.1, we have two physical NICS connected to seperate network to our iSCSI EMC SAN. We currently have three 400 GB datastores setup.
We are building a SQL server running Windows 2008 R2. What is the best option for database storage.
Should you create s second hard drive and have it point to the same data store that VM is using?
Or, is there a way to setup an iSCSI initiator and point to an ISCSI LUN on the SAN specifically setup for the databse for this server? This is how we have our physical SQL servers setup now? If this is possible how do you set this up, so the VM Guest OS can see this ISCSI LUN that is on a seperate network from VM's?
What is the best practice solution for this scenario?
Thanks,
MIchael