tigertoolbox/Always-On/leasetimeout

Least Timeouts

This folder provides the Power BI Desktop file along with the T-SQL queries for creating and extracting relevant information from Extended Event traces for tracking lease timeouts for Availability Groups.

CreateXESession.sql - Extended event session definition to track Always On AG lease timeout

LeaseTimeoutXEData.sql - Extract the data from the Always On AG extended event trace and store the extracted data in a tempdb table

LeaseTimeout.pbix - Provides easy to use visualizations using the extracted data from the Lease timeout related Extended Events

SQL Server improvements for lease timeout are documented in KB3112363

A recording of the SQL PASS HADR Virtual Chapter session where this information was presented is available on YouTube