Avatar of mohssinm
mohssinm
 asked on

Best Desgin for SQL Server on Vmware ?

Dear all,

        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 ?



Thanks
 
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
mohssinm

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
patkremer

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
mohssinm

ASKER
Hi ,

   Thanks for all those information . It really helpful . So let me understand for critical Application with physical cluster but for medium application will go VMWare .

  Thats look good for me but how can improve VMWare guest with standalone SQL Sever .I mean what is best to use like some feature in VM like HA or choose log-shipping or mirroring in SQL ?
patkremer

HA protects you against physical hardware failure - it restarts your VM on another physical server if the server the VM is running on dies. It offers no protection if there's actually something wrong with the VM like an OS or SQL corruption.

Log shipping is simply a way to ensure that your transaction logs are applied to another SQL server so you have a ready-to-run copy of your database online.  If your primary VM goes down, you have the backup available with some manual intervention.

We generally don't use log shipping for the VMs - we are confident that our restore process is fast enough to get us back to where we need to be. We have used it to back up a non-clustered physical node though.
mohssinm

ASKER
There is no direct and clear answer . it was describing
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
mohssinm

ASKER
Thanks patkremer