SPID in Blk By is itself
This is a discussion on SPID in Blk By is itself within the SQL Server forums, part of the Microsoft SQL Server category; --> I am seeing intermittent blocking problems. The strange part of it is, that the SPID listed in the Blk ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-01-2008, 11:56 AM
| ||||
| ||||
 SPID in Blk By is itself 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?      |
|
03-01-2008, 11:56 AM
| ||||
| ||||
| Re: SPID in Blk By is itself Absinthe (BradleySmall@gmail.com) writes: > 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. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
Linear Mode
