Best Desgin for SQL Server on Vmware ?
Posted on 2011-03-04
as we have around three cluster env for SQL 2005,2008 for Many Apps as well for SharePoint .
Now we decide to go through VMware .I know the VM is a great product when I decide to go with VM I understand the support through SVV program and all of version of SQL Supported on ESX 6.
but now when I discuss with VM engineer I found SQL Cluster is supported on VM but when we install cluster VM is working fine and everything wokring great BUT when I check VM feature like Snapshot ,VMotion is not supported with VM only standalone . So it was big challenge as well review design something is must ?
My question in my case it is better to go with Standalone with many servers OR go with Cluster option . Of course still we have one physical server for critical systems .
with Cluster we loose many feature + complex troubleshooting .
with STD alone will be easier but it will be many servers as well many management?
Looking for best ?