Always On availability groups

GPTKB entity

Statements (37)
Predicate Object
gptkbp:instanceOf high availability technology
gptkbp:canBe gptkb:SQL_Server_Management_Studio
gptkb:Transact-SQL
gptkbp:developedBy gptkb:Microsoft
gptkbp:distinctFrom replication
database mirroring
log shipping
gptkbp:documentation https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-availability-groups-sql-server
gptkbp:enables automatic failover
manual failover
readable secondary replicas
gptkbp:features gptkb:Microsoft_SQL_Server
https://www.w3.org/2000/01/rdf-schema#label Always On availability groups
gptkbp:introducedIn gptkb:SQL_Server_2012
gptkbp:mayInclude up to 8 secondary replicas (SQL Server 2016 and later)
up to 2 synchronous replicas (SQL Server 2016 and later)
gptkbp:monitors gptkb:SQL_Server_Management_Studio
gptkbp:partOf SQL Server Always On suite
gptkbp:provides disaster recovery
high availability
gptkbp:requires gptkb:SQL_Server_Enterprise_Edition
Windows Server Failover Cluster (WSFC)
gptkbp:supports asynchronous-commit mode
multiple databases
synchronous-commit mode
automatic page repair
backup on secondary replicas
listener for client connections
distributed availability groups (SQL Server 2016 and later)
read-scale availability groups (SQL Server 2016 and later)
gptkbp:uses gptkb:Windows_Server_Failover_Clustering
gptkbp:bfsParent gptkb:64-bit_SQL_Server
gptkb:SQL_Server_Enterprise_Edition
gptkb:SQL_Server_database
gptkb:SQL_Server_(mssql)
gptkb:Microsoft_SQL_Server_family
gptkbp:bfsLayer 7