sp_clusterlockusage

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

Syntax

sp_clusterlockusage

Examples

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.

SettingDescription
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.