Hi,

sp_who2 is useful for blocking. it will show which SPID is blocked by whom.

Then you can use DBCC INPUTBUFFER (SPID ID) to see what the SPID is actually doing i.e the T-SQL used by the SPID.

also, have a look at : http://technet.microsoft.com/en-us/library/cc966540.aspx

hope this helps,

\\K 🙂