Sybase 12.4.2 manual 474

Monitoring the buffer caches

	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 -iooption 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 -bufallocThe -buffallocoption produces results like the following. option

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

474