monOpenObjectActivity and monOpenPartitionActivity

monOpenObjectActivity and monOpenPartitionActivity add these columns for analyzing lock acquisitions.

Name

Datatype

Description

PhsyicalLocks

int4

Number of physical locks requested per object.

PhsycialLocksRetained

int4

Number of physical locks retained. You can use this to identify the lock hit ratio for each object. Good hit ratios imply balanced partitioning for this object.

PhysicalLocksDeadlocks

int4

Number of times a physical lock requested returned a deadlock. The Cluster Physical Locks subsection of sp_sysmon uses this counter to report deadlocks while acquiring physical locks for each object.

PhysicalLocksWaited

int4

Number of times an instance waits for a physical lock request.

PhysicalLocksPageTransfer

int4

Number of page transfers that occurred when an instance requests a physical lock. The Cluster Physical Locks subsection of sp_sysmon uses this counter to report the node-to-node transfer and physical-lock acquisition as a node affinity ratio for this object.

PhysicalLocksRetainWaited

int4

Number of physical lock requests waiting before a lock is retained.

TransferReqWaited

int4

Number of times physical lock requests waiting before receiving page transfers.

AvgPhysicalLocksWaitTime

int4

The average amount of time clients spend before the physical lock is granted.

AvgTransferReqWaitTime

int4

The average amount of time physical lock requests wait before receiving page transfers.

TotalServiceRequests

int4

Number of physical lock requests serviced by the Cluster Cache Manager of an instance.

PhysicalLocksDowngraded

int4

Number of physical lock downgrade requests serviced by the Cluster Cache Manager of an instance.

PagesTransferred

int4

Number of pages transferred at an instance by the Cluster Cache Manager.

ClusterPageWrites

int4

Number of pages written to disk by the Cluster Cache Manager of an instance.

AvgServiceTime

int4

The average amount of service time spent by the Cluster Cache Manager of an instance.

AvgTimeWaitedOnLocalUsers

int4

The average amount of service time an instance’s Cluster Cache Manager waits due to page use by users on this instance.

AvgTransferSendWaitTime

int4

The average amount of service time an instance’s Cluster Cache Manager spends for page transfer.

AvgIOServiceTime

int4

The average amount of service time used by an instance’s Cluster Cache Manager for page transfer.

AvgDowngradeServiceTime

int4

The average amount of service time the Cluster Cache Manager uses to downgrade physical locks.

Required parameters

None