Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 490 / 536

Monitoring the buffer caches
470
• AvPF: Number of currently available buffers for prefetch quota
allocation
• Slots: Number of currently registered objects using buffer cache quota
• PinUser: Number of objects using pin quota
• PFUsr: Number of objects using prefetch quota
• Posted: Number of objects that are pre-planned users of quota
• UnPost: Number of objects that are ad hoc quota users
• Locks: Number of mutex locks taken on the buffer allocator
• Waits: Number of times a thread had to wait for the lock
•
-contention
displays many key buffer cache and memory manager locks
• AU: Current number of active users
• LRULks: Number times the LRU was locked (repeated for the temp
cache)
• woTO: Number times lock was granted without timeout (repeated for
the temp cache)
• Loops: Number times IQ retried before lock was granted (repeated for
the temp cache)
• TOs: Number of times IQ timed out and had to wait for the lock
(repeated for the temp cache)
• BWaits: Number of "Busy Waits" for a buffer in the cache (repeated
for the temp cache)
• IOLock: Number of times IQ locked the compressed I/O pool
(repeated for the temp cache)
• IOWait: Number of times IQ had to wait for the lock on the
compressed I/O pool (repeated for the temp cache)
• HTLock: Number of times IQ locked the blockmaps hash table
(repeated for the temp cache)
• HTWait: Number of times IQ had to wait for the blockmaps hash table
(repeated for the temp cache)
• FLLock: Number of times IQ had to lock the free list (repeated for the
temp cache)