Always On Availability Groups
GPTKB entity
Statements (61)
| Predicate | Object |
|---|---|
| gptkbp:instance_of |
gptkb:Sungard_Availability_Services
|
| gptkbp:allows |
automatic failover
|
| gptkbp:can_be_configured_for |
manual failover
cross-platform support T-SQL commands automatic page repair synchronous or asynchronous replication |
| gptkbp:can_be_used_for |
read scale-out
|
| gptkbp:can_be_used_to |
minimize downtime
improve application performance support compliance requirements scale out read workloads support hybrid cloud scenarios facilitate maintenance operations without downtime replicate data across geographic locations |
| gptkbp:can_be_used_with |
gptkb:SQL_Server_Reporting_Services
gptkb:Azure_SQL_Database virtual machines |
| gptkbp:deployment |
cloud environments
on-premises environments |
| gptkbp:developed_by |
gptkb:Microsoft
|
| gptkbp:enhances |
disaster recovery
|
| gptkbp:feature |
gptkb:Microsoft_SQL_Server
supports high transaction volumes enables seamless failover. improves application availability provides flexibility in deployment options reduces the risk of data loss |
| https://www.w3.org/2000/01/rdf-schema#label |
Always On Availability Groups
|
| gptkbp:includes |
primary replica
secondary replicas |
| gptkbp:introduced_in |
gptkb:SQL_Server_2012
|
| gptkbp:is_a_solution_for |
business continuity
data protection |
| gptkbp:is_compatible_with |
SQL Server Agent jobs
|
| gptkbp:is_designed_for |
high availability and disaster recovery
|
| gptkbp:is_documented_in |
Microsoft documentation
|
| gptkbp:is_integrated_with |
gptkb:Active_Directory
|
| gptkbp:is_managed_by |
gptkb:SQL_Server_Configuration_Manager
|
| gptkbp:is_monitored_by |
gptkb:SQL_Server_Management_Studio
Performance Monitor |
| gptkbp:is_part_of |
SQL Server Always On
SQL Server Always On architecture SQL Server high availability solutions |
| gptkbp:is_supported_by |
gptkb:SQL_Server_Data_Tools
|
| gptkbp:is_used_in |
enterprise environments
mission-critical applications |
| gptkbp:is_used_to |
ensure data availability
|
| gptkbp:provides |
load balancing
database mirroring failover clustering |
| gptkbp:requires |
gptkb:Windows_Server_Failover_Clustering
SQL Server Enterprise Edition for some features |
| gptkbp:supports |
multiple databases
readable secondary replicas up to 8 secondary replicas listener for client connections backup and restore operations on secondary replicas |
| gptkbp:bfsParent |
gptkb:My_SQL
gptkb:Microsoft_SQL_Server |
| gptkbp:bfsLayer |
4
|