I need to change the LEASE TIMEOUT on an Availability Group on hundreds of SQL Servers. I have seen the following command for changing the HEALTH_CHECK_TIMEOUT -
ALTER AVAILABILITY GROUP AG_Name SET (HEALTH_CHECK_TIMEOUT = 600000) ;
But there doesn't seem to be any TSQL for changing the LEASE TIMEOUT -
Am I overlooking the obvious? I would prefer to avoid having to manually change the LEASE TIMEOUT value in the Failover Cluster Manager on all of these servers.
Thanks