Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm looking at the Activity Monitor in SQL Server 2008 Management Studio.

I see that a lot of processes indicates that it is a blocking process, by the value of 1 in the Head Blocker column.

Is this normal, or am I potentially dealing with an issue here?

alt text

share|improve this question

2 Answers 2

No, not normal

The locks causing the blocking will usually be held because of

  • inadvertent open transaction (ie not committed or rolled back)
  • long running transaction/statement (eh a delete taking hours)
  • client command timeout without SET XACT_ABORT

You could KILL the offending spid but this fixes the symptom not the cause

A very useful script to start finding out what is wrong: open transactions with text and plans:

share|improve this answer

Yes this is an issue. You have some transaction(s) holding locks longer than you would like, perhaps the holder went out to lunch?

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.