SQL Server Always On Availability Groups

GPTKB entity

Statements (32)
Predicate Object
gptkbp:instanceOf high availability technology
gptkbp:canBeDeployedOn on-premises
cloud environments
hybrid environments
gptkbp:developedBy gptkb:Microsoft
gptkbp:enables automatic page repair
backup on secondary replicas
automatic redirection of connections
gptkbp:features gptkb:Microsoft_SQL_Server
https://www.w3.org/2000/01/rdf-schema#label SQL Server Always On Availability Groups
gptkbp:introducedIn gptkb:SQL_Server_2012
gptkbp:monitors Availability Group Dashboard
gptkbp:provides disaster recovery
high availability
gptkbp:replacedBy gptkb:Database_Mirroring
gptkbp:requires gptkb:Windows_Server_Failover_Clustering
SQL Server Enterprise Edition (pre-2016)
gptkbp:supports automatic failover
manual failover
multiple databases
readable secondary replicas
listener for client connections
up to 8 secondary replicas (SQL Server 2016 and later)
asynchronous commit mode
automatic seeding (SQL Server 2016+)
read-scale out
synchronous commit mode
Basic Availability Groups (SQL Server Standard Edition, 2016+)
gptkbp:uses endpoints for data movement
log transport mechanism
gptkbp:bfsParent gptkb:Cluster_Operating_System_Rolling_Upgrade
gptkbp:bfsLayer 7