Filter
Top Products
CHAPTER 13 Monitoring and Tuning Performance
473
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
-append option.
Examples of monitor results
This section shows sample results using different monitor options.
Example of -summary
option
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:
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 -cache
option
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
1999-01-17 17:43:55