Knowledge Base

cancel
Showing results for 
Search instead for 
Did you mean: 

How do I increase the maximum SQL capture length?

If you have changed your SQL capture settings from filter parameter values to capture raw SQL, longer SQL queries are now truncated to 999 characters. To change this character limit within the Controller, edit or register a new node property.

 

In the Controller UI, click on Tiers and Nodes in the left navigation bar. Then double click on the node you'd like to configure, and click Agents > App Server Agent > Configure. This will open the App Server Configuration window. 

 

At the node level, click on the Use Custom Configuration button. Then either search for the max-length-batch-sql property and double click on it, or click on the gray plus sign to create a new agent property if the max-length-batch-sql property does not already exist.

 

In the Create Agent Property window, provide values for the name, description, type, and value of the new property (see example and screenshot below). Click the save button to close the window.

 

Then click the save button after adding the new configuration. A "saved successfully" message should appear in the top right corner of the window when done correctly.

 

Lastly, exit the App Server Configuration window and click the reset button. This will allow the agent to inherit the new changes.

 

For additional information, see documentation on how to add a registered node property.

 

Example:

Name = max-length-batch-sql
Description = Increases character limit for SQL queries

Type = Integer
Value = 2000

 

 

App Server Configuration window

 

Version history
Revision #:
11 of 11
Last update:
‎12-22-2018 01:02 PM
Updated by:
 
Labels (1)
Comments

Is there any limit on the # of characters for SQL query?

We increased to 2000 and these are still truncated and I have been requested to change to 4000.

 

Hi @Sanjay.Girotra

 

  • There is a 500-character limit on the length of the SQL statement. Do not use any truncated queries that might appear in the SQL Statements list or a snapshot.
  • The overall number of executions of SQL queries configured to collect Analytics data is limited to 10K. This is configurable using the analytics-sql-cpm-limit node property. See App Agent Node Properties Reference1.
 See Collect Business Data from SQL Calls for further details.