Sybase 12.4.2 Server User Manual


 
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)