Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

PERF_MONITOR

PERF_MONITOR <option>

The SYSMON feature allows entries to be placed on a queue for client side processing and monitoring of server events. This option allows event entries to be specified in the ctsrvr.cfg configuration file. The following options are supported:

ALL_EVENTS

CHECKPOINT

LOG_EXTENSION

LONG_TRANSACTION

When checkpoints are monitored, an entry is written to the SYSMON_PERF client-side queue for the beginning and end of each checkpoint. Log extensions similarly generate begin and end entries. A long transaction generates one entry.

ALL_EVENTS is equivalent to listing each individual option.

When one or more event types have been enabled, then the first entry written into the SYSMON_PERF queue provides the information necessary to convert the high-resolution times into seconds and/or dates.

See Also

TOCIndex