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