Sybase 12.4.2 - Manual (Page 495)

CHAPTER 13 Monitoring and Tuning Performance
475
Example of
-contention option Note The actual -contention output shows Main Cache, Temp Cache, and
Memory Manager on the same line. Because this format is very wide, each of
these sets of columns is shown separately here.
The -contention results for the main cache are:
Options string for Main cache:
"-contention -file_suffix contention-iqmon -append -interval 10"
Contention
2000-01-24 10:57:03
AU| Main Cache |
|LRULks woTO Loops TOs BWaits IOLock IOWait HTLock HTWait FLLock FLWait
0 66 0 0 0 0 1 0 5 0 4 0
1 2958 0 0 0 0 160 0 1117 0 6 0
1 1513 0 0 0 1 378 0 2 0 8 0
1 370 0 0 0 0 94 0 2 0 10 0
1 156 0 0 0 0 46 0 2 0 12 0
1 885 0 0 0 0 248 0 2 0 14 0
1 1223 0 0 0 0 332 1 2 0 16 0
1 346 0 0 0 0 66 0 2 0 18 0
The - contention results for the temp cache are:
Temp Cache
|LRULks woTO Loops TOs BWaits IOLock IOWait HTLock HTWait FLLock FLWait
70 0 0 0 0 1 0 4 0 5 0
466 0 0 0 0 2 0 15 0 12 0
963 0 0 0 0 2 0 8 0 20 1
1186 0 0 0 0 2 0 2 0 23 1
357 0 0 0 0 2 0 2 0 25 1
444 0 0 0 0 2 0 3 0 29 0
884 0 0 0 0 2 0 2 0 31 1
1573 0 0 0 0 2 0 5 0 37 1
The results for the memory manager are:
| Memory Mgr
MemLks MemWts
55483 13
5705 0
2048 0
186 4