Dell High Availability and Disaster Recovery Solutions Using Microsoft SQL Server 2012 AlwaysOnAvailability Groups4Executive summaryOrganizations typically require that their critical applications are available to end users on acontinuous basis, and thus the need for reliable solutions that provide High Availability (HA) andDisaster Recovery (DR) continues to increase. Most HA and DR solutions available today use multipleredundant components to extend these vital capabilities to hosted data. Several factors are importantwhen choosing the best and most appropriate HA and DR solutions for a given infrastructure, includingreliability, robustness, cost, efficiency, automation, ease-of-use, and related performance impacts tothe hosted application.In this technical paper, we will discuss an important HA and DR feature, Microsoft SQL Server 2012AlwaysOn Availability Groups (AVG), and how it addresses the issues mentioned above when deployedon Dell™ 12th Generation PowerEdge™ Servers. The guidelines and recommendations for implementingAVG will be illustrated by a review of some of the possible user scenarios. We will also discuss howPowerEdge Servers can be combined in a variety of server and storage configurations that make Dellthe right platform for deploying Microsoft AlwaysOn HA and DR solutions.IntroductionAchieving the best possible level of availability and recovery of critical applications is a big challenge.Many problems—software failures, hardware failures, planned and unplanned downtimes to name just afew—can make the critical data unavailable.High Availability features provide continuous access to the applications/infrastructure, and aregenerally achieved by having redundant hardware and software combination located within the sameroom or a datacenter. Disaster Recovery, on the other hand, is a recovery plan which will be used whenthe primary setup is not accessible. Usually a DR setup is located at the remote site rather than thesame site of primary setup.Recovery Time Objective (RTO) and Recovery Point Objective (RPO) are the important metrics thathelp customers in choosing the best suitable HA and DR solution for a given application. RTO refers tohow long a customer can afford to go without a given application being available for use. Theappropriate HA solution has to be implemented so that the application recovers from failure within anacceptable time period.RPO refers to the amount of data that a customer determines it can afford to lose in the case of adisaster/outage. This dictates the kind of recovery solution that needs to be in place for a givenapplication. Achieving the required RPO and RTO goals involves ensuring continuous uptime of criticalapplications and protection of critical data from unplanned and planned downtime.Choosing the right hardware components such as servers, storage, and switches for implementing a HAand DR solution can significantly benefit the customers in terms cost, performance, and availability ofthe application. The servers and different storage options chosen for implementing the AlwaysOn AVGhave a great impact on performance and failback/failover times. In the following sections, we will