Microsoft KB Archive/158327

= PRB: Extra Insert_page Locks Held on a Page Split with IRL =

Article ID: 158327

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q158327



SYMPTOMS
Under the following circumstances, insert_page locks may be held on pages that a client has not inserted on:


 * The client has inserted to a table with Insert Row Locking (IRL) enabled in a transaction that has not been committed yet.

-and-
 * Another client performs an INSERT to the same table, causing a new page to be added to the table.



MORE INFORMATION
The extra insert_page locks held by the other clients are needed for transactional integrity. They do not cause any additional blocking because the other clients are already blocked from further inserts until the client with the link_page lock commits its transaction.

Additional query words: link_page

Keywords: kbbug kbfix kbnetwork kbusage KB158327

-

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

© Microsoft Corporation. All rights reserved.