The sp_ dropglockpromote_ptn and sp_droprowlockpromote_ptn system procedures remove partition-lock promotion thresholds at the server, database, and table level.