There is a huge blockings on my Production server.
When i run sp_who2 i could see many spid's are involved in these blockings.
It is difficult to check the command for each and every SPID (around 30- 40 spid's) using dbcc inputbuffer and to find the root blocker.
Is there any logic or query/procedure to find out the root blocking spid.
View Complete Post