This is a very good script to find blocking chain with lead blocker. I got this script from Pinal dave
Continue readingTag: Blocking chain in SQL SERVER
Performance Tuning :- How to identify blocking And Lead blocker in SQL Server
During normal processing in a database, it is blocked. Blocking is “by design” because your database is on ACID.
Continue reading