FIX: Users Blocking With No Locks Displayed in sp_lock |
Q138603
Many users performing queries against tables with non-clustered indexes on
symmetric multiprocessing (SMP) computers with more than two processors can
get processes blocking each other, but there are no related locks shown
by sp_lock. KILLing the blocker may or may not alleviate the problem. This
problem is very rare.
If KILL fails to alleviate the blocking, shut down and restart SQL Server. The problem is caused by applications issuing many "cancels" and can be alleviated by reducing the number of cancels sent to the server.
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem was corrected in Service Pack 2 for SQL Server version 6.0. For more information, contact your primary support provider.
Additional query words: sql6 blocking sp_lock windows nt
Keywords : kbprogramming
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600
|
Last Reviewed: March 11, 2000 © 2001 Microsoft Corporation. All rights reserved. Terms of Use. |