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 |
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
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
ScanInterval=1
InputTrigger=Time
InputValue=10
CommitTrigger=Count
CommitValue=5000
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*