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