Setting Partition Lock Promotion Thresholds

The sp_setpglockpromote_ptn and sp_setrowlockpromote_ptn system procedures set partition-lock promotion thresholds at the server, database, and table level.

Related reference
sp_setpglockpromote_ptn
sp_setrowlockpromote_ptn