Viewing AG Lease Renewals (SQL Server 2016 Standard)

  • We have been getting AG Lease Timeouts. The cause is being investigated and looks to be storage IO performance related. Anyway, I increased the lease timeout as mitigation but was wondering if there was any way of seeing the lease timeout renewal process in action?

    I wanted to confirm the new timeout value is being used somehow.  I have the situation where I'm not getting timeouts but I don't know if that's due to the larger lease timeout value or the problem not occurring to cause the timeout.

    I can see when timeouts occur via the Alwaysonhealth extended even session, but it doesn't seem to have  anything for successful renewals.  I have seen articles that reference a hadr_ag_lease_renewal  extended event but I can't seem to locate that event.

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply