Working On It
I’ve been re-working a lot of the demos in a presentation that I’m working on called Index Internals That Matter For Performance, because after a first walk through them, I had a lot of realizations about …
Category: Locking
Locking And Blocking Week: Recap
Sonic Deducer
This week I’m giving away a sampling of the videos from my Locking and Blocking course.
If you want to see the entire thing, it’s available this week for just .99 cents.
All you have to do …
Locking And Blocking Week: Weird Blocking
Dead and Alive
This week I’m giving away a sampling of the videos from my Locking and Blocking course.
If you want to see the entire thing, it’s available this week for just .99 cents.
All you have to …
Locking And Blocking Week: Tuning Begin Tran
Beginning OF The Tran
This week I’m giving away a sampling of the videos from my Locking and Blocking course.
If you want to see the entire thing, it’s available this week for just .99 cents.
All you have …
Locking And Blocking Week: Tuning Blocking With Indexes
All This And More
This week I’m giving away a sampling of the videos from my Locking and Blocking course.
If you want to see the entire thing, it’s available this week for just .99 cents.
All you have …
Locking And Blocking Week: Introduction
I Wanna Know What Lock Is
This week I’m giving away a sampling of the videos from my Locking and Blocking course.
If you want to see the entire thing, it’s available this week for just .99 cents.
All …
Lock Waits Come From Blocking, Not Locks Being Taken
Waiting Game
In SQL Server, troubleshooting blocking problems is a pain. It’s one of those things you really have to be monitoring for pretty actively in order to catch the full extent of it.
You might catch glimpses of it …
Indexed View Maintenance Is Only As Bad As Your Indexes
Wah Wah Wah
Yes, indexed view maintenance can be quite rough. I don’t mean like, rebuilding them. I will never talk about that.
I mean that, in some cases locks are serializable, and that if you don’t mind your …
Waiting For Deadlocks
Try And Retry
I’ll sometimes see people implement retry logic to catch deadlocks, which isn’t a terrible idea by itself. The problem that may arise is when the deadlock monitor takes a full 5 seconds to catch a query, which …
Isolation Level <> Locking
Different Engines
I seem to have gotten quite a few questions about this lately, so I’m going to write down some thoughts here.
It’s probably crappy form for a blog post, but what the heck.