Sybase 12.4.2 Server User Manual


 
Monitoring the buffer caches
474
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
Example of -io option
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
1998-08-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
Example of -bufalloc
option
The -buffalloc option produces results like the following.
Options string for Main cache: "-bufalloc -file_suffix bufalloc-iqmon -
append -interval 10"
Buffer Allocation
2000-01-24 10:58:39
OU/AU MaxBuf Avail AvPF Slots PinUsr PFUsr Posted UnPost Quota Locks
Waits
1/0 1592 1592 20 0 0 0 0 0 0 1 0
1/1 1592 1592 20 0 0 0 0 0 0 1 0
1/1 1592 1592 20 0 0 0 0 0 0 1 0