beautypg.com

Sybase 12.4.2 User Manual

Page 494

background image

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