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