Always On availability groups
GPTKB entity
Statements (36)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb: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
|
| 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:Microsoft_SQL_Server_family |
| gptkbp:bfsLayer |
7
|
| https://www.w3.org/2000/01/rdf-schema#label |
Always On availability groups
|