Video unavailable

SQLBits 2018

Headaches of Blocking, Locking, and Deadlocking

It strikes fear in your heart: "Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim." Learn the basics of how SQL Server handles blocking, locking, and deadlocking.

It strikes fear in your heart: "Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim." Learn the basics of how SQL Server handles blocking, locking, and deadlocking as Microsoft Certified Master Brent Ozar demos LCK% waits and deadlocks, then shows how to fix them with query changes, index improvements, and isolation level tweaks.

Speaker

Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com.

Brent Ozar's Sessions

The Ascending Key Problem

300-Level Guide to Career Internals: Planning Your Career

500-Level Guide to Career Internals: Building a Brand

Fragmentation Explained in 20 Minutes

The New Robots in SQL Server 2017, 2019, 2022, and Azure

Fundamentals of Stored Procedures

300-Level Guide to Career Internals: Planning Your Career

500-Level Guide to Career Internals: Building a Brand

Deadlocks: Lets Do One, Understand It, and Fix It

"But It Worked in Development!" 3 Hard Performance Problems

Headaches of Blocking, Locking, and Deadlocking

Easy Performance Tuning: an Intro to Wait Statistics

Cool Story, Bro: The DBAreactions Guide to SQL Server 2014

How to Pick SQL Server Hardware

How the SQL Server Engine Thinks

Watch Brent Tune Queries

Virtualization and SAN Basics for DBAs

SQL Server Storage - 1,000GB Level

T-SQL Tuning with Colin Chapman, Enzo Ferrari, and The Stig

Using Perfmon and Profiler