If you are a Managed Hosting customer, this topic doesn't apply to you.
SIS Logging verbosity is set to Errors Only by default. Several clients have reported performance issues when this setting is configured to All Diagnostic and Debug Messages. Processing thousands of records using All Diagnostic and Debug Messages can cause problems due to large increase in database memory usage.
If All Diagnostic and Debug Messages must be turned on, clients should increase the log cleanup frequency from the default value of 30 days to 10 or less. This configuration is exposed in config/internal/data-integration.properties:
# How much days worth of entries should be saved during automatic purges