• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 300
  • Last Modified:

Blocking and deadlock on SQL Server

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'


Tks
0
AXISHK
Asked:
AXISHK
1 Solution
 
HuaMinChenBusiness AnalystCommented:
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now