SQL Server 2022 Clusterless Distributed Availability Group

This article shows the final step of an availability group creation, specifically for a distributed clusterless one.

Secondary Query Store

AG Rules for Databases

The AG Synchronous Replicas

The AG Secondary Logs

Basic Always On Availability Groups in SQL Server Standard

Once Windows Server Failover Clusters have been set up, we can set up Availability Groups in SQL Server. This article will focus on setting up Basic Always-On Availability Groups in SQL Server Standard Edition.
This facilitates High Availability in SQL Server Standard, with three levels of availability and failover:
Asynchronous commit with manual or forced failover,
Synchronous commit with manual or forced failover,
Synchronous commit with automatic failover.

Troubleshoot SQL Server Always On Availability Groups with SQL LogScout

We experienced several unplanned outages and failovers on our SQL Server Always On Availability Groups. We want to know the root cause to prevent them from happening in the future. How do we identify the root causes of unplanned Availability Group outages and failovers?

Read Only Replica in SQL Server Standard

SQL Server Standard Always On Availability Groups

Always On Setup