self-blocking session

• Pieter-423357

  SSCommitted

  Points: 1619

  More actions

  August 10, 2009 at 8:32 am

  #156086

  Hi everyone,

  When reviewing the sever log of one of my SQL2005 servers I noticed a "self-blocking session" and it pertained to creating a clustered index. It took quite some resources and causes some other programs to crash on an insert statement.

  I tried to find some info on this topic, but Google is thin on it. Do you guys have any references or explanations what it a 'self-blocking session ' and what causes this?

  Thanks a bunch!

• Jason Miller-476791

  SSCommitted

  Points: 1540

  More actions

  August 10, 2009 at 11:11 am

  #1036909

  It's not actually blocking itself. What you're witnessing is sp_who is reporting on waits for (I think) page IO Latches...

  There's a page out there describing the differences in sp_who between 2K and 2005. This is one of them.

  Honor Super Omnia-
  Jason Miller