SQL Benefits of AlwaysOn Asychronous vs Mirroring Asychronous

by BlueLamp82   Last Updated June 18, 2018 01:06 AM

What are the current benefits of Alwayson AvailabilityGroups Asynchronous vs SQL Mirroring High Performance Asynchronous? I know couple advantage are,

1) AlwaysOn allow Read queries on the secondary replica, Mirroring does not allow this

2) AlwaysOn allows groups of databases to failover, Mirroring does not allow

Are there anymore? Can someone document ? We know they are deprecating Mirroring by the way, we just want a basic disaster recovery system for the next couple years



Related Questions


SQL Server Always ON

Updated May 15, 2016 08:02 AM


AlwaysOn AG - CPU limitations

Updated April 07, 2015 20:02 PM

SQL Why is Microsoft deprecating Mirroring?

Updated June 17, 2018 00:06 AM