Spinlock activity
(INSTANCEID, SPINLOCKNAME)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| GRABS | double | Total number of grabs |
| SPINS | double | Total number of spins |
| WAITS | double | Total number of waits |
| GRABSWRAP | long | Internal-use number of grabs on wrapped counter; created by Surveillance |
| SPINSWRAP | long | Internal-use number of spins on wrapped counter; created by Surveillance |
| WAITSWRAP | long | Internal-use number of waits on wrapped counter; created by Surveillance |
| SPINLOCKCOUNT | long | Number of spinlocks in the array associated with the spinlock name. For example, a partitioned data cache with 16 partitions might have 16 spinlocks in the array. |
| CONTENTION | double | Waits / Grabs; 0, if Grabs = 0 |
| SPINLOCKSLOTID | long | ID of first spinlock in each array |
| SPINLOCKNAME | string(80) | Spinlock name |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| GRABS_DELTA | double | Delta number of grabs |
| GRABS_RATE | double | Number of grabs per second, in interval |
| GRABS_OVERALL | double | Total number of grabs, since collection started |
| SPINS_DELTA | double | Delta number of spins |
| SPINS_RATE | double | Number of spins per second, in interval |
| SPINS_OVERALL | double | Total number of spins, since collection started |
| WAITS_DELTA | double | Delta number of waits |
| WAITS_RATE | double | Number of waits per second, in interval |
| WAITS_OVERALL | double | Total number of waits, since collection started |
| CONTENTION_PCT | double | Contention %, since ASE instance started |
| CONTENTION_CUR_PCT | double | Contention %, in interval |
| CONTENTION_OVERALL_PCT | double | Contention %, since collection started |
| SPINS_PER_WAIT | double | Delta number of spins / delta number of waits |
| SPINS_PER_WAIT_OVERALL | double | Spins / Waits, since collection started |
| Attributes: | None |
|---|---|
| Minimum database version: | 12.5.0.3 |