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

[@FrancescoMantovani]

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

[@TheBrentOzar]

Aww, thanks! Glad you enjoyed it.

[@tylervandermate]

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

[@jingyuanfang5947]

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!

[@SQLBits]

Glad it helped!

[@igormulyar4832]

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

[@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.

[@jonathangurwitz7863]

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

[@mertsahin6752]

so so so sooo thanks man. you are marvelous

[@travelchimps6637]

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

[@SQLBits]

Thank you for the lovely feedback!

[@MahmoudIsmail-rw7hg]

I really like your explanation

[@SQLBits]

Thank you! 😃

[@georgebordiuh1616]

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

[@SQLBits]

Glad it helped!

[@ayoubihbibibi2404]

Oh my god , this guy is really great !

[@Axsanchez]

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

[@SQLBits]

Not a problem!

[@becker8192]

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

[@markdepaur1726]

nice content, i love the style of your teaching.....

[@ajupeter1125]

Impressive! Thanks Brent..

[@sql6081]

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

[@ashishranjan9731]

Awesome way to explain ❤

[@vaibhavwani2094]

Great stuff, Great Explanation!!

[@anonymous8633]

Nice!

[@raulkishore]

Thank you Brent

[@TheBrentOzar]

My pleasure!

[@JackyMa-he2ji]

Pretty awesome.

[@HemantKChitale]

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

[@ashwiniprabhu735]

This content was very meaningful :)

[@geoffroutzahn99]

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.

[@geoffroutzahn99]

just saw at 10:39 that was acknowledged....never mind.

[@divijjawarani]

how to run the spBlitzlock thing?

[@komismo]

My god you just save my ass. TY for this.

[@jcrussell5723]

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)

[@photographymaniac2529]

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?

[@SQLBits]

Hi, you can get in touch with the speakers directly through LinkedIn and X! They are normally more than happy to help.

[@photographymaniac2529]

@@SQLBits thanks 🙏

[@hassanOnYoutube]

Love from Pakistan

[@AntonioRonde]

How much of this is applicable to Postgres v14?

[@SQLBits]

Hey! Any questions you can ask the host yourself - Twitter @BrentO

[@sql6081]

Dear Brent, Would you please be able to release a version of sp_BlitzLock that works in Azure SQL. I run your latest sp_BlitzLock in Azure SQL and it throws an error: ==================================================================== Msg 40538, Level 16, State 3, Procedure sp_BlitzLock, Line 913 [Batch Start Line 10] A valid URL beginning with '' is required as value for any filepath specified. ====================================================================

[@williameisenman5538]

Every Database Application that I have ever coded retries on SQL Error 1205

[@Phoenixspin]

I clicked for dreadlocks, not this.

[@SQLBits]

Sorry, deadlocks here not dreadlocks!

[@veloX-tg1tx]

I will never know if any of your videos are helpful or knowledgeable because I cannot get past the preponderance of unnecessary antics.

[@SQLBits]

Hey! You can get in touch with the speakers who taught this video via LinkedIn and Twitter if you have any questions/feedback!

[@ricardotomasoyola3085]

I cant run the procedure. It says A valid URL beginning with '' is required as value for any filepath specified.

[@SQLBits]

Hi Ricardo, it's worth getting in touch with Brent directly to answer your issue, this is easiest via LinkedIn or Twitter!