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 analyse a single or multiple deadlock graphs using XdlCheck. More, this session will teach you the basic things about pesimist/optimist concurency in SQL Server.

3 things you'll get out of this session

Deadlock, Deadlock Graph, XDL, XdlCheck

Bogdan Sahlean's other proposed sessions for 2026

Actual - 2026

Adaptive Join in SQL Server 2005/2008 - 2026

DBCubes - 2026

JUMP - 2026

Searchable Query - 2026

STATISTICS IO With Query Associated Output - 2026