sp_clusterlockusage output has been enhanced to print cluster lock usage information that is specific to partition locks.
Lock Usage count % of total ------------------------- ------------ ------------ Total Locks 1479860 n/a Free Locks 1469318 99.29 % Used Locks 10542 0.71 % Object Locks 7948 0.54 % Physical Locks 1864 0.13 % Table Locks 0 0.00 % Partition Locks 8 0.00 % Page Locks 0 0.00 % Row Locks 42 0.00 % Others 680 0.05 %