Skip to content

Increasing SQL query character limit

This page explains how to adjust the displayed character limit for SQL queries tracked by FusionReactor's JDBC monitoring, both for on-premise and Cloud environments. Increasing or disabling this limit allows you to view complete long SQL queries for better code efficiency analysis and issue rectification.

Understanding the issue

FusionReactor's JDBC tracking provides insights into SQL queries executed within your transactions. However, by default, the displayed text of long SQL queries may be truncated in the interface. This limitation can hinder your ability to fully understand and debug complex database interactions.

Solution: Adjusting the SQL text limit

FusionReactor offers settings to increase the default character limit for displayed SQL queries or disable it entirely.

On-Premise environment

  1. Navigate to JDBC Settings: In the FusionReactor on-premise UI, locate and click on the JDBC section in the left-hand navigation menu.
  2. Access Logging / Metrics Settings: Within the JDBC section, click on the Settings tab. Under this tab, find the Logging / Metrics subsection.
  3. Modify SQL Text Limiting: Locate the setting labeled SQL Text Limiting (Log and Display).
  4. Adjust the Character Limit:
    • Increase the Limit: Change the numerical value from the default of 1000 to a higher number that accommodates your typical long queries.
    • Disable the Limit: Set the value to 0 to disable the character limit entirely.

Cloud environment

To view the full SQL queries in FusionReactor Cloud transactions, you need to perform two steps:

  1. Apply On-Premise Settings: As described in the On-Premise environment section, adjust the SQL Text Limiting (Log and Display) setting within the on-premise tab of your FusionReactor Cloud server configuration.

  2. Add JVM Argument: Apply the following JVM argument to your application server instance:

    -Dfr.observability.trace.value.limit=1000

    Adjust the value 1000 in the JVM argument as necessary to match or exceed the character limit you set in the on-premise UI.

Important considerations

  • Memory usage: Increasing or disabling the SQL text limit can potentially increase FusionReactor's memory usage, as it will need to store and display larger query strings.
  • Monitoring for impact: After adjusting the settings, monitor your FusionReactor instance for any unexpected performance or memory impact. If you observe any issues, you can revert the settings to their previous values once you have completed your troubleshooting.

By following these steps, you can customize the SQL query display limit in FusionReactor for both on-premise and Cloud environments, enabling you to gain a comprehensive view of your database interactions.