High availability

SQL Server high availability: Always On availability groups, Basic Availability Groups in Standard edition, timeouts, dbatools and troubleshooting.

Basic Availability Groups in Standard edition

The Standard edition of SQL Server offers one high availability solution: Basic Availability Groups. Here are their benefits and their limits.

Always On: mastering the timeouts

Lease Timeout, HealthCheck, Quorum… Configure the SQL Server and WSFC thresholds to stabilize your high availability.

Troubleshooting AlwaysOn availability groups

Collect the SQL Server logs, the AlwaysOn_health files and the WSFC logs (Get-ClusterLog) to troubleshoot an availability group.

Use dbatools for AlwaysOn availability groups

Using dbatools to manage and troubleshoot AlwaysOn availability groups in SQL Server.