sp_clusterlockusage

(Cluster environments only) Reports on the free, used, and retained locks in the cluster .

Syntax

sp_clusterlockusage

Examples

Example 1 – 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 %

Usage

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.

Permissions

The permission checks for sp_clusterlockusage differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be a user with `manage cluster privilege` or a user with ha_role.
Disabled	With granular permissions disabled, you must be a user with sa_role or ha_role.