Blocking and deadlock on SQL Server
Posted on 2014-02-12
I want to find out any blocking or deadlock on the SQL Server.
Using sp_who2, there is nothing under field "BlkBy'.
If I use "select * from sysprocesses where blocked >0' I see a record setup. Does it mean this task is blocked some resource on the server ? In addition, what is meaning for 'AWAITING COMMAND' under column 'cmd'