看目前使用多少lock數

select count(*) from master..syslocks;

或
sp_monitorconfig "of lock" (此語法還可看到設定)
---------------------------------------------------------------------------------
Name, Num_free,Num_active,Pct_act,Max_Used,Reuse_cnt
'number of locks',249, 1,'0.17',250,0