Sybase 12.4.2 manual 470

Monitoring the buffer caches

•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

•-contentiondisplays 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)

470