info@techdevops.com | 437-991-3573 | Data Engineering Services
TechDevOps.com
Resources Tools Services
Experts in Microsoft SQL Server on Windows, Linux, Containers | Clusters, Always On, FCI | Migrations, Cloud, Performance



Microsoft SQL Server Always On Availability Groups Architecture Design
by BF (Principal Consultant; Architecture; Engineering)
2021-09-05







The Always On Availability Groups (AGs) feature is a high-availability and disaster-recovery solution that maximizes the availability of a set of user databases for an enterprise data estate.

Always On AGs are SQL Server’s premier HA/DR technology.

Always On AGs consist of the following main components: (Windows + SQL)

(1) Availability Group - contains user database(s).
(2) Primary replica - principal SQL Server Instance.
(3) Secondary Replica(s) - failover target SQL Server Instance.
(4) Windows Server Failover Cluster - a group of independent servers that work together to increase the availability of applications and services.
(5) Listener - unique DNS name that serves as a virtual network name (VNN).

Here is a typical architecture design for a 3-node, multi data center infrastructure.