Availability Group – How to Reduce False Failovers During Short Infrastructure Outages

To reduce false failovers during short infrastructure outages, it is common to increase:

1. LeaseTimeout — communication timeout between SQL Server Availability Group and WSFC from 20s to 60s

SQL:

ALTER AVAILABILITY GROUP [AG1]
SET (LEASE_TIMEOUT = 60000);

2. PendingTimeout — cluster resource timeout from 180s to 600s

PS:

(Get-ClusterResource "AG1").PendingTimeout = 600000