Sybase 12.4.2 User Manual

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

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