INF: Table Locking De-Escalation

ID: Q45643


The information in this article applies to:
  • Microsoft SQL Server for OS/2, version 4.2

If SQL Server escalates to table locking because so many individual pages are locked that it is more efficient to lock the entire table, it returns to page-level locking when the locks can be freed at the end of the transaction (whether a COMMIT or ROLLBACK).

Additional query words:

Keywords : kbother SSrvServer
Version : OS/2:4.2
Platform : OS/2
Issue type :


Last Reviewed: January 4, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.