README.md 869 B
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