(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 % Partition Locks 9 0.00 % 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.
The permission checks for sp_clusterlockusage differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be a user with manage cluster privilege or a user with ha_role. |
Granular permissions disabled |
With granular permissions disabled, you must be a user with sa_role or ha_role. |
