Sybase 12.4.2 manual Examples of monitor results, Buffer cache, 473

CHAPTER 13 Monitoring and Tuning Performance

When you run the monitor again from the same database and connection number, by default it overwrites the previous results. If you need to save the results of a monitor run, copy the file to another location before starting the monitor again from the same database or use the -appendoption.

Examples of monitor results

Example of -summary option

This section shows sample results using different monitor options.

The -summaryoption 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:

Options string for private cache: "-summary -interval 5"

					Summary
				1998-08-18 14:07:51
Users		Main Cache							Temp Cache
C/A	Finds	HR%	Reads/	GDirty	Pin%	Finds		HR% Reads/ GDirty Pin%
			Writes						Writes
0/0	347	100.0	0/0	0	0.1	1219 100.0			0/0	0	8.8
0/0	163	98.8	2/0	0	0.1	357	100.0		0/0	0	0.0
0/0	4662	99.8	10/0	0	3.7	1740 100.0			0/0	0	7.8
0/0	1386	99.8	3/0	0	0.2	1716 100.0			0/0	0	0.3
0/0	1472	91.2	129/0	0	6.1	1327 100.0			0/0	0	3.2
0/0	1152	99.7	3/0	0	0.8	4137 100.0			0/0	0	2.8
0/0	262	97.7	6/0	0	1.7	1149	100.0		0/0	0	0.4
0/0	1358	98.0	27/0	0	0.1	853 100.0			0/0	0	5.4
0/0	321	80.1	64/0	0	1.9	458	100.0		0/0	0	4.3
0/0	102	82.4	18/0	0	1.9	14	100.0		0/0	0	5.8
0/0	104	82.7	18/0	0	1.9	64	100.0		0/0	0	4.7
0/0	85	81.2	16/0	0	1.3	14 100.0			0/0	0	6.2
0/0	1 100.0		0/0	0	0.1	1974	100.0		0/0	0	0.1
0/0	736	86.1	102/0	0	2.2	1070 100.0			0/0	0	6.8
0/0	79 100.0		0/0	0	0.1	4109	100.0		0/0	0	0.4
0/0	518	96.1	20/0	0	0.1	1576 100.0			0/0	0	0.0
0/0	1083	86.2	149/0	0	0.1	1578 100.0			0/0	0	0.2
0/0	704	99.3	5/0	0	0.1	1240	100.0		0/0	0	0.4
0/0	872	100.0	0/0	0	4.0	1764 100.0			0/0	0	0.8
0/0	346	87.0	45/2	2	0.1	597	100.0		0/0	0	7.8

Example of -cacheThe -cacheoption produces results like the following, which are for the temp

option	buffer cache.
Options string for Temp cache: "-cache		-interval	10"
	Temp Shared	Buffer Cache
	1999-01-17 17:43:55

473