monCLMObjectActivity

Description

(Cluster environments only) Collects cluster lock information. monCLMObjectActivity:

Tracks activity for objects only in the master and user databases.
Tracks physical lock activity at the partition level.

Cluster object locks for a database have an Object-PartitionID of 0.

Enable the enable monitoring configuration parameter for this monitoring table to collect data.

Columns

monCLMObjectActivity contains these columns:

Column name	Type	Description
InstanceID	int1	Instance ID.
DBID	int4	Database ID.
Object_PartitionID	int4	Identity of the object making the lock request.
LockRequests	int4	Number of cluster lock requests.
LocalMaster	int4	Number of times a lock request finds the current instance to be the lock master. One instance in the cluster becomes the “lock master.” When an instance needs a cluster lock, it contacts the lock master for the lock.
Waited	int4	Number of lock requests granted with contention at the remote instance.
Granted	int4	Number of lock requests granted without contention at the remote instance.
RWConflictWaited	int4	Number of lock requests that waited because of a read-write conflict lock that was granted to a task at a remote instance.
AvgRWConflictWaitTime	flt4	Average amount of time spent performing the wait described by RWConflictWaited.
MaxRWConflictWaitTime	flt4	Maximum amount of time spent performing the wait described by RWConflictWaited.
WWConflictWaited	int4	Number of lock requests that waited because of a write-write conflict lock that was granted to a task at a remote instance.
AvgWWConflictWaitTime	flt4	Average amount of time spent performing the wait described by WWConflictWaited.
MaxWWConflictWaitTime	flt4	Maximum amount of time spent performing the wait described in WWConflictWaited.
ClusterMsgWaits	int4	Number of waits due to cluster messaging.
AvgClusterMsgWaitTime	flt4	Average wait time due to cluster messaging.
MaxClusterMsgWaitTime	flt4	Maximum wait time due to cluster messaging.
DowngradeReqRecv	int4	Number of downgrade service requests received at the cluster lock owner.
DowngradeReqRecvWithNoBlocker	int4	Number of the downgrade service requests received without any blocking task ownership at cluster lock owner.
ClusterDeadlock	int4	Number of deadlocks caused by multiple instances attempting to acquire the same cluster lock simultaneously.
Locktype	varchar(20)	Type of lock.