|
SQL Server Administration: AlwaysOn Enhancement - More Failover Targets
-by Ginger Keys
In AlwaysOn 2012 and 2014, you were allowed a maximum of two replicas to designate for automatic failover. AlwaysOn 2016 allows three replicas for automatic failover. You must have synchronous data replication and automatic failover set between the primary and the secondaries.
Automatic failover is generally used to support high availability, and because of synchronous data flow, there is near zero data loss in the event of failover.
___________________________________________________________________________
SQLRx has worked hard to minimize the impact of monitoring SQL Servers to the point that we are able to monitor high transaction systems with little impact (1% load) on the target system. Contact us today to help you monitor your SQL servers!
| 
