This section shows sample results using different monitor options.
The -summary option produces results like the following. Note that it shows both main and temp buffer cache statistics, no matter which you request in the IQ UTILITIES command:
Sybase Adaptive Server IQ Performance Monitor --------------------------------------------- Version 3.2Options string for Main cache: "-summary -interval 5" Summary 2004-07-16 13:53:24Active| Main Cache | Temp Cache Users| Finds HR% Reads/Writes GDirty Pin% Dirty% InUse%| Finds HR% Reads/Writes GDirty Pin% Dirty% InUse% 0 286 99.3 2/34 0 0.0 1.6 26.2 608 99.7 2/47 0 0.0 3.6 20.0 1 2621 99.4 16/155 0 5.6 8.7 81.7 4121 99.6 16/163 0 11.4 23.2 67.3 1 2646 99.8 6/48 0 1.6 13.5 100.0 3388 99.8 6/70 1 4.1 40.9 94.5 1 2684 99.9 7/78 0 5.6 14.3 100.0 3497 99.9 8/103 1 10.9 42.3 99.1 1 1993 99.9 17/22 0 4.0 31.0 100.0 3342 98.7 122/149 0 8.2 41.4 91.4 1 2479 99.9 32/110 0 5.6 13.5 100.0 3370 99.8 55/112 0 11.4 45.5 95.9 1 3273 100.0 0/0 0 5.6 23.8 100.0 3951 100.0 0/108 1 13.6 49.1 100.0 1 2512 99.9 2/0 0 1.6 31.0 100.0 3916 98.9 88/173 0 5.5 48.6 100.0 1 1264 99.9 66/131 0 4.0 45.2 100.0 4317 98.9 378/305 0 6.4 40.0 77.3 1 2122 99.8 30/125 0 5.6 12.7 99.2 3122 99.7 67/127 0 12.3 40.0 90.5 1 3370 100.0 2/0 0 5.6 23.0 100.0 4034 100.0 2/98 2 13.2 46.4 98.2 1 2981 99.9 2/0 0 5.6 31.7 100.0 3715 99.9 2/110 0 14.1 53.2 100.0 1 3351 99.6 13/3 0 5.6 39.7 100.0 4131 99.7 13/123 0 14.1 57.7 100.0 1 3286 99.6 13/13 0 5.6 40.5 100.0 4135 99.6 15/139 0 12.3 55.9 97.7 1 296 100.0 0/0 0 1.6 41.3 100.0 3646 96.9 366/320 0 7.3 53.2 100.0 1 1230 99.4 71/129 0 6.3 58.7 100.0 4221 98.9 390/297 0 9.5 59.1 91.8 1 1900 100.0 125/279 0 4.0 50.0 100.0 4102 100.0 344/279 0 7.7 38.6 72.3 Sybase Adaptive Server IQ Performance Monitor --------------------------------------------- Shutting Down 0 422 98.8 16/99 0 0.0 0.8 99.2 853 98.9 34/101 0 0.0 1.8 59.1
The -cache option produces results like the following, which are for the temp buffer cache.
Options string for Temp cache: "-cache -interval 10"
Temp Shared Buffer Cache
2001-02-18 17:43:55
Finds Creats Dests Dirty HR% BWaits ReReads FMiss Cloned Reads/ PF/ GDirty Pin% Dirty%
Writes PFRead
Tm: 640 82 57 84 99.4 0 4 0 0 4/0 0/0 0 0.0 2.8
Tm: 1139 109 83 109 100.0 0 0 0 0 0/0 0/0 0 0.0 5.5
Tm: 6794 754 749 754 100.0 0 0 0 0 0/0 0/0 0 0.0 6.1
Tm: 10759 1646 1646 1646 100.0 0 0 0 0 0/0 0/0 0 0.0 6.1
The -io option produces results like the following, which are for the main buffer cache:
Options string for main cache: "-IO -interval 5"
Main Buffer Cache
2001-02-18 13:58:48
Input Output
Reads Lrd(KB) Prd(KB) Rratio Writes Lwrt(KB) Pwrt(KB) Wratio
Mn: 10 40 34 1.18 14 56 23 2.43
Mn: 0 0 0 0.00 21 84 34 2.43
Mn: 0 0 0 0.00 7 28 11 2.43
Mn: 0 0 0 0.00 22 88 35 2.48
Mn: 0 0 0 0.00 63 252 100 2.51
Mn: 0 0 0 0.00 54 216 93 2.32
Mn: 0 0 0 0.00 64 256 101 2.52
Mn: 0 0 0 0.00 62 248 94 2.62
Mn: 0 0 0 0.00 73 292 110 2.65
Mn: 0 0 0 0.00 105 420 121 3.47
The -buffalloc option produces results like the following.
Options string for Main cache: "-bufalloc -file_suffix bufalloc-iqmon -append -interval 10" Buffer Allocation 2001-02-18 10:58:39OU/AU MaxBuf Avail AvPF Slots PinUsr PFUsr Posted UnPost Quota Locks Waits 1/0 1592 1592 20 0 0 0 0 0 0 1 01/1 1592 1592 20 0 0 0 0 0 0 1 01/1 1592 1592 20 0 0 0 0 0 0 1 0
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 2001-02-18 10:57:03
Main Cache | AU |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 2 0 137 0 22 0 203 3
The results of the -threads option look like the following:
Options string for Main cache: "-threads -file_suffix threads-iqmon -append -interval 10" Threads 2001-02-18 10:59:24 CPUs Limit NTeams MaxTms NThrds Resrvd Free Locks Waits 10 100 4 12 100 13 68 106 590 10 100 6 12 100 12 63 4 6 10 100 6 12 100 12 63 0 0 10 100 7 12 100 12 62 1 1 10 100 7 12 100 12 62 0 0 10 100 7 12 100 12 58 1 5 10 100 7 12 100 12 58 0 0
