Locking

Deploy at Low Priority

A utility script for deploying schema changes without a maintenance window - using a time-based loop, lock checking, and GOTO to minimize blocking on busy SQL Servers.

How to 5 min read Blocking · Locking

2025-03-07

Service Broker Blocking

I was paged for a blocking chain where the lead blocker had a transaction name I'd never seen: CSbRollbackHandlerTask::DisableQ. Here is how I reproduced it and why the blocked process report refuses to help.

Deep Dive 4 min read Blocking · Debugging

2024-08-09

Unexpected Blocking during the Indexed View Creation

Here are the chronicles of my struggles to add a large Clustered index to a View without causing an outage.

Investigation 4 min read Debugging · Locking

2022-09-05

IS Lock in RCSI Enabled Database

I found an IS lock in a deadlock report on an RCSI database. That shouldn't be possible. Here's what caused it.

Investigation 6 min read Extended Events · Debugging

2021-11-22