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