SPID in Blk By is itself

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Absinthe - 29 Dec 2006 19:31 GMT

I am seeing intermittent blocking problems. The strange part of it is,
that the SPID listed in the Blk By column is the same as the SPID that
is being blocked.

Has anyone seen this before, or have any idea what this may suggest?

Reply to this Message

Erland Sommarskog - 29 Dec 2006 22:14 GMT

> I am seeing intermittent blocking problems. The strange part of it is,
> that the SPID listed in the Blk By column is the same as the SPID that
> is being blocked.
>
> Has anyone seen this before, or have any idea what this may suggest?

http://support.microsoft.com/default.aspx/kb/906344 tells you all about it.

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Reply to this Message