BUG: Parallel Process May Not Appear Blocked in the sp_who System Stored Procedure (264689)
The information in this article applies to:
This article was previously published under Q264689
BUG #: 57975 (SQLBUG_70)
SYMPTOMS
The sp_who and sp_who2 stored procedures may not show when a process that is running with a parallel plan is blocked. Results are returned with the blk (sp_who) or BlkBy (sp_who2) showing 0 for a system process ID (SPID) that is actually blocked. Those columns should show the SPID that is blocking the affected SPID.
WORKAROUND
To work around this problem, use the sp_lock system stored procedure to see if one of the locks for the relevant SPID has a status of WAIT. To identify the blocking SPID, you must analyze the Resource that the SPID is requesting a lock for and determine what other SPID has a lock already on this resource. For additional information about monitoring blocking, click the article number below
to view the article in the Microsoft Knowledge Base:
251004 INF: How to Monitor SQL Server 7.0 Blocking
STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.
| Modification Type: | Major | Last Reviewed: | 10/16/2002 |
|---|
| Keywords: | kbBug KB264689 |
|---|
|