Sybase 12.4.2 User Manual
CHAPTER 13 Monitoring and Tuning Performance
475
Example of
-contention option
-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.
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