Microsoft KB Archive/150896

= FIX: SH_PAGE Locks May Be Held on Inner Tables of JOINs =

Article ID: 150896

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q150896



BUG #: 15329 (6.50)



SYMPTOMS
A join of tables may hold the shared page locks on the inner tables of the join(s) for the duration of the SELECT.



CAUSE
The page locks on the inner table(s) of joins where a unique index matches the join on the inner table are not released until the end of the SELECT. On earlier versions, SQL Server would obtain and release the locks one at a time as the page chain is traversed. The outer table's page locks are not held. If the tables are large, this can be a significant concurrency impact. This did not happen in prior versions of SQL Server.



WORKAROUND
Use non-unique indexes instead of unique.



STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

Additional query words: sql65 join lock

Keywords: kbbug kbfix kbprogramming KB150896

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.