Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Deadlocking for Mere Mortals

PASS Data Community Summit via YouTube

Start learning Write review
DataCamp Ad

AI Engineer - Learn how to integrate AI into software applications

Learn More → Unihackers Ad

Launch Your Cybersecurity Career in 6 Months

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This session explains common SQL Server deadlocks and how to troubleshoot them using trace flags, SQL Trace, event notifications, and Extended Events. It also covers lock behavior, deadlock priority, and interpreting process and resource lists.

Syllabus

Introduction
About Jonathan
Overview
Misconceptions
Terminology
Lock Types
Lock Escalation
Lock Compatibility
Whats a Deadlocking
Lock Monitor Thread
Deadlocking Priority
Deadlocking Victim
SQL Server Trace Flags
Legacy Trace Flags
Event Notifications
Tracing and Extended Events
Victim Process
Resource List
Process List

Taught by

PASS Data Community Summit

Reviews

Start your review of Deadlocking for Mere Mortals

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.