MonitorTuning parameters

The MonitorTuning parameters help you control how the High-speed Apply Engine displays progress messages during an apply request. The progress messages display statistics about the SQL statements that High-speed Apply Engine has processed as input and committed against the target tables.

Parameter

Reference

CommitTrigger

CommitValue

InactivityInterval

InputTrigger

InputValue

ScanInterval

Related topic

Command-and-syntax-reference

High-speed Apply Engine displays progress messages during an apply request, so that you can determine:

  • How many SQL statements in the input file High-speed Apply Engine has examined and dispatched to an agent for application to the target tables
  • How many SQL statements High-speed Apply Engine has committed against the target tables

Use the following guidelines to adjust progress messages with these parameters:

  • Set the parameters to display fewer progress messages for existing apply requests that you run frequently in production.
  • Set the parameters to display more frequent progress messages as you tune the performance of a new apply request, or to diagnose an existing apply request that experiences performance or other problems.

The following figures show examples of [MonitorTuning] parameters:

 Example of production [MonitorTuning] parameters

[MonitorTuning]
  ScanInterval=1
  InputTrigger=Time
  InputValue=300
  CommitTrigger=Count
  CommitValue=10000

Example of diagnostic [MonitorTuning] parameters

[MonitorTuning]
  ScanInterval=1
  InputTrigger=Time
  InputValue=10
  CommitTrigger=Count
  CommitValue=5000


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*