Using TSQL in SQL Server to analyse the deadlock graph events
Proposed session for SQLBits 2026TL; DR
Tell me about deadocks
Deadlock Graphs
How we intercept ?
Pesimist/optimist concurency
Deadlock structure
Analysis of a single event
The analysis of multiple events
Session Details
This session will teach you how to create a basic deadlock and how to fast analyse a single or multiple deadlock graphs using XdlCheck.
3 things you'll get out of this session
Deadlock, Deadlock Graph, XDL, XdlCheck