Provides statistics about spinlock activity.
Enable the enable spinlock monitoring configuration parameter for this monitoring table to collect data.
The columns for monSpinlockActivity are:
Name |
Datatype |
Description |
|---|---|---|
SpinlockName |
varchar(255) |
Name of spinlock |
| SpinlockSlotID | int | ID for this spinlock in the spinlock memory pool |
Grabs |
bigint |
Number of grabs for this spinlock |
Spins |
bigint |
Number of spins on this spinlock |
Waits |
bigint |
Number of waits for this spinlock |
OwnerPID |
int |
Current owner Process Identifier |
LastOwnerPID |
int |
Previous owner Process Identifier |
Contention |
real |
Spinlock contention, as percentage |
InstanceID |
tinyint |
(Cluster environments only) ID of an instance in a shared-disk cluster. |