(Cluster environments only) Reports on the free, used, and retained locks in the cluster.
sp_clusterlockusage
Reports the locks currently used in the cluster:
Lock Usage count % of total ------------------------- ------------ ------------ Total Locks 95039 n/a Free Locks 85807 90.29 % Used Locks 9232 9.71 % Object Locks 4032 4.24 % Physical Locks 233 0.25 % Table Locks 0 0.00 % Page Locks 0 0.00 % Row Locks 17 0.02 % Others 501 0.53 % Retention Used 0 0.00 %
Retention Used reports
on the number of locks that are not owned by any task, but are owned
at the cluster level because of lock retention.
