22-25 April 2026

Using TSQL in SQL Server to analyse the deadlock graph events

Proposed session for SQLBits 2026

TL; 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