Shahid Roofi Khan

Microsoft Technologies Blog

SQL Always-On - Choose between Async vs Sync Replication mode.

SQL Always-ON is great technology. Often times architects and decision makes get stuck on a model of replication to decide in it. Confusion arises from the fact that it provides two flavors of replication: synchronous as well as asynchronous. Both approaches come with pros and cos.

Just to settle the confusion and reference for all decision makes and architects, I've documented the MS Article available at below MS Link:

Checkout my Microsoft Article Posting: https://social.technet.microsoft.com/wiki/contents/articles/52671.sql-alwayson-choosing-between-the-right-replication-model.aspx

Further Reading: Microsoft Article