monOpenObjectActivity and monOpenPartitionActivity

PhsyicalLocks

int

Number of physical locks requested per object.

PhsycialLocksRetained

int

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

int

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

int

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

PhysicalLocksPageTransfer

int

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

int

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

TransferReqWaited

int

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

AvgPhysicalLocksWaitTime

int

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

AvgTransferReqWaitTime

int

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

TotalServiceRequests

int

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

PhysicalLocksDowngraded

int

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

PagesTransferred

int

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

ClusterPageWrites

int

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

AvgServiceTime

int

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

AvgTimeWaitedOnLocalUsers

int

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

AvgTransferSendWaitTime

int

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

AvgIOServiceTime

int

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

AvgDowngradeServiceTime

int

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