In previous releases of SQL Server, once a statement accumulated more than 200 page locks on a table, SQL Server tried to issue a table lock on that object. If the table lock succeeded, the page locks were no longer necessary and were released.
The lock promotion HWM, lock promotion LWM, and lock promotion PCT configuration parameters and the sp_setpglockpromote system procedure configure the number of page locks that SQL Server acquires on a table before it attempts to escalate to a table lock on a server-wide, per database, and per table basis.
For more information, see Chapter 5, “Locking in Adaptive Server,” in the Performance and Tuning Guide.
