Coming soon — this article is being prepared. Below are its question, intended outcome, and place in the story.
The question
How can you find a long transaction blocking another operation?
What we will work through
Find a long transaction blocking another operation.
Before you begin
Previously covered: Row locks and deadlocks.