Running Microsoft SQL Server on VMware vSphere offers many options for database availability, backup and disaster recovery utilizing the best features from both, VMware and Microsoft.
VMware recently published its guidelines for use and configuration of availability and recovery options. Furthermore, VMware published an updated version of its best practices guide for Microsoft SQL Server on vSphere.
Check the newest versions which have been recently updated for vSphere 6.5…
1. Guidance on Availability and Recovery Options
Using vMotion or vSphere Distributed Resource Scheduler can help to reduce planned downtime and balance workloads dynamically, and vSphere High Availability can help to recover SQL Server databases in the case of host failure.
SQL Server availability features can be used inside a virtual machine just as you would on a physical server, and combined with vSphere features to support flexible availability and recovery scenarios.
VMware’s newly provided whitepaper gives insights in the options and guidance for deploying highly available Microsoft SQL Server on vSphere. The recommendations included in this guide are not specific to particular hardware or to the size of any particular SQL Server implementation.
For access to the whitepaper, check Microsoft SQL Server on VMware vSphere – Availability and Recovery Options.
2. Best Practices for Microsoft SQL Server
Learn the best strategy to virtualize MS SQL Server to achieve the business requirements while keeping operations overhead to a minimum for cost effectiveness.
For access to the newest version of the whitepaper, check Architecting Microsoft SQL Server on VMware vSphere.