desperadomar (11/18/2013)
So how will I find the root blocker, whether is it a chained blocking etc...Thank you
I like to use sp_who2 and/or Adam Machanic's WhoIsActive to determine the root blocker.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes