LinkedIn | FaceBook | Twitter
You get three main bands. The outer one is arranged by the Transaction ID:
The next band shows the statement that is being blocked. It starts off with the Blocking SQL Statement:
The last band just shows the Blocked SQL Statement – but that may perhaps the most important piece of the puzzle. That’s often where you’ll get your first indication that something is wrong.
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today I'm