I am trying to setup a Microsoft SQL 2012 cluster with one physical and one (standby) VM node. Physical Windows server node will access common storage using iSCSI initiator and the VM node will do so using RDM disks.
This is a supported configuration, but finer details are missing from VMware documentation:
When I put Windows server in the same SAN group on Dell Compellent iSCSI storage as VMware hosts, I got in big trouble because Windows server tried to access VMFS volumes, even though I kept them offline in Disk Management. All VMs went down one by one.
So I wish to know the safe way to deploy disks in this SQL cluster. The Windows server is now outside the SAN group but it needs to access the same 4 disks which are connected to standby VM node as RDMs. Will mapping those 4 volumes to both VMware Hosts Group and Windows server (not in that group) cause any issue? For the OS of the VM, I have used the standard VMFS volume, and all RDM disks have placed their VMDK files on the path of that VMFS volume, which concerns me. Should I use only RDM disks in the VM node, even for OS? Thanks.