Dell High Availability and Disaster Recovery Solutions Using Microsoft SQL Server 2012 AlwaysOnAvailability Groups14Advantages and limitations of implementing AVG on shared storageAdvantages: Cost effective HA and DR solution for Enterprise Customers Instance level protection using FCIs Support of multi-subnet FCI clustering enables a DR solution using AlwaysOn with multi-subnetFCI Flexible failover policy for granular trigger events for automatic failovers Support for variety of storage types and configurations at each site (iSCSI, FC, SAS etc.) May benefit from enhanced SAN featuresLimitations: No Automatic failover/failback support for FCI when it is combined with AVG functionalityAVG deployments on hybrid (HDD and SSD) storageIn HA and DR solutions, it is always a good practice to use high performing drives such as SSDs in theprimary site to get faster failover benefits and high performing databases within the primary site. Dell12th generation servers (such as the R720 and R820) come with support for front-loading PCIe SSDdrives.BenefitsDell™ PowerEdge R720 and R820 servers support up to four 2.5-inch 350G front-access PCIe SSDs drives.Figure 7 shows a possible deployment of AlwaysOn Availability Groups on the PCIe SSDs drives of DellPowerEdge servers.AVG deployments on SSD and HDDFigure 7.