sp_setpglockpromote_ptn

Sets partition-lock promotion thresholds at the server, database, and table level.

Syntax

The syntax for setting the partition lock promotion threshold at the server level is:
sp_setpglockpromote_ptn "server", null, new_lwm, new_hwm, new_pct
The syntax for setting the partition lock promotion threshold at the database or table level is:
sp_setpglockpromote_ptn "database | table", objname, new_lwm, new_hwm, new_pct

Parameters

Examples

Permissions

Any user can execute sp_setpglockpromote_ptn.