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

You keep getting warnings and emails about deadlocks, but let's be honest: you're not really sure how they happen or what to do about it. Brent Ozar will show one, use sp_BlitzLock to analyze it, then fix it.

Tags: Optimising,On-prem,Cloud,SentryOne,indexing,execution plans,Database engine,Blocking

[charliegordon]

Incredibly helpful and easy to understand. Thanks for your time Brent.

[tylervandermate]

Absolutely love this format! It's so clear and keeps your attention. Great stuff

[jingyuanfang]

One of the best tutorial I ever saw!!! (I haven't watched too much but still) Really helpful, time and life saver! Also love the style of it!

[FrancescoMantovani]

I learned more things in the last hour that in the last 2 weeks. Thank you Brent

[jonathangurwitz]

This was awesome. Thanks. Really comprehensive. I loved the screaming crowd :)

[igormulyar]

Great job! So clear explanation, excellent presentation format! Kudos to you!

[mertsahin]

so so so sooo thanks man. you are marvelous

[travelchimps]

Amazing session!! So interractive, so engaging, so funny, kept me hooked the whole time. Thank you!

[ayoubihbibibi]

Oh my god, this guy is really great !

[HemantKChitale]

"I don't know anyone who actually does that". Yes, I agree. I have never seen a developer concerned about deadlocks and coding to retry a transaction.

[geoffroutzahn]

at 10:01 I noticed that you don't explicitly run BEGIN TRAN. Was that on purpose? Maybe you address this as an oversight in the video later or someone else asked the same thing below but I just stopped at that very moment and added the comment.

[markdepaur]

nice content, i love the style of your

[Axsanchez]

Seriously you saved my life, just kidding, tbh this is a really helpful video thanks for doing this

[georgebordiuh]

Great video, thanks, even though I'm using MySQL!)

[HemantKChitale]

And I have been frequently asked "why can't you [the DBA] predict or control which session's transaction will be terminated" !

[photographymaniac]

This is really good technique, but what to do when we are using some form of ORM like Entity Framework in C# or JPA in Java? Is there a way to handle these?

[becker]

Upvote for Jenkins". Actually, the whole video is great. Thanks.

[AntonioRonde]

How much of this is applicable to Postgres v14?

[jcrussell]

If you are gamer instead of thinking Reservoir Dogs you can put the Red Dead Redemption 2 final scene before you get to the epilogue (providing you go for the loot)

[sql]

Brent Ozar is
Danny DeVito,
Tom Hanks
of the SQLWorld 🙂What a great guy.