Sybase 12.4.2 Manuale Utente
Monitoring the buffer caches
470
•
AvPF: Number of currently available buffers for prefetch quota
allocation
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)
cache)
•
woTO: Number times lock was granted without timeout (repeated for
the temp cache)
the temp cache)
•
Loops: Number times IQ retried before lock was granted (repeated for
the temp cache)
the temp cache)
•
TOs: Number of times IQ timed out and had to wait for the lock
(repeated for the temp cache)
(repeated for the temp cache)
•
BWaits: Number of "Busy Waits" for a buffer in the cache (repeated
for the temp cache)
for the temp cache)
•
IOLock: Number of times IQ locked the compressed I/O pool
(repeated for the temp cache)
(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)
compressed I/O pool (repeated for the temp cache)
•
HTLock: Number of times IQ locked the blockmaps hash table
(repeated for the temp cache)
(repeated for the temp cache)
•
HTWait: Number of times IQ had to wait for the blockmaps hash table
(repeated for the temp cache)
(repeated for the temp cache)
•
FLLock: Number of times IQ had to lock the free list (repeated for the
temp cache)
temp cache)