Sybase 12.4.2 contentionresults for the main cache are, contentionresults for the temp cache are

CHAPTER 13 Monitoring and Tuning Performance

Example of

-contention option

Note The actual -contentionoutput 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 -contentionresults 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 -contentionresults 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

475