Database Administrator's Guide

LOG_TEMPLATE_COPY_SLEEP_TIME <milliseconds>

When working with large log templates on high volume systems, the log template copy operation can consume excessive I/O time impacting performance. By periodically deferring the copy operation, this can smooth out I/O spikes. This option causes the copying of the log template to pause for the specified number of milliseconds each time it has written the percentage of data specified by the LOG_TEMPLATE_COPY_SLEEP_PCT option to the target transaction log file.

If an error occurs using this method to copy the log template, the code logs an error message to CTSTATUS.FCS (look for "LOG_TEMPLATE_COPY: ...") and attempts to use the original log template copy method.

A suggested time is 5 ms to start with.

Default: 0 (disabled)
Minimum value: 0
Maximum value: 1000 (1 second sleep)

See Also

• LOG_TEMPLATES
• LOG_TEMPLATE_COPY_SLEEP_PCT