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
|