search cancel

Tomcat SQL parameters clarification

book

Article ID: 202036

calendar_today

Updated On:

Products

CA Application Performance Management Agent (APM / Wily / Introscope) CA Application Performance Management (APM / Wily / Introscope) INTROSCOPE DX Application Performance Management

Issue/Introduction

This is Openshift application. I am seeing duplicate sql parameter settings and not sure which ones are relevant to controlling the SQL parameters.

SQL Param Agent: configured max sql param string length at 100

 [INFO] [IntroscopeAgent.Agent] SQL Param Agent: configured show params to false

 [INFO] [IntroscopeAgent.Agent] SQL Param Agent: configured resolve Bind-Params to false

 [INFO] [IntroscopeAgent.Agent] SQL Agent: TurnOff Metrics Configuration (introscope.agent.sqlagent.sql.turnoffmetrics) set to "true"

 [INFO] [IntroscopeAgent.Agent] SQL Agent: Report Only ART Metric Configuration (introscope.agent.sqlagent.sql.artonly) set to "false"

 [INFO] [IntroscopeAgent.Agent] SQL Agent: Raw SQL In Trace Configuration (introscope.agent.sqlagent.sql.rawsql) set to "false"

 

SQL Parameters

IntroscopeAgent.SqlParamAgent] Configured max sql query string length at 500

[INFO] [IntroscopeAgent.SqlParamAgent] Configured max sql param string length at 100

[INFO] [IntroscopeAgent.SqlParamAgent] Configured show connection URL to false

[INFO] [IntroscopeAgent.SqlParamAgent] Configured show params to false

[INFO] [IntroscopeAgent.SqlParamAgent] Configured result set row counting to false

[INFO] [IntroscopeAgent.SqlParamAgent] Configured resolve Bind-Params to false

[INFO] [IntroscopeAgent.SqlParamAgent] Configured max tracked prepared statements 1000

[INFO] [IntroscopeAgent.SqlParamAgent] Configured max tracked result sets 1000

 

It appears there are two sets of parameters for example query string is 100 in one setting 500 in other.

I was trying to override them in -Javaoptions with -D so want to know what parameters to use to make sure the SQL settings are set the way I want.

 

 

Environment

Release : 20.2

Component : APM Agents

Resolution

Logs

[INFO] [IntroscopeAgent.SqlParamAgent] Configured max sql query string length at 500 -- QUERY
[INFO] [IntroscopeAgent.SqlParamAgent] Configured max sql param string length at 100 --PARAM



Only ones with 500 & 100

# maximum size of SQL statement traced
#
# Changing this property requires restarting the Monitored Process
introscope.agent.sqlagent.sql.maxlength=500

# maximum size of SQL parameter traced
#
# Changing this property requires restarting the Monitored Process
introscope.agent.sqlagent.maxparamlength=100



What I see in yours with emphasis. The PARAM is always 100 and does not change.

Query is another variable.

SQL Param Agent: configured max sql PARAM string length at 100

IntroscopeAgent.SqlParamAgent] Configured max sql QUERY string length at 500
[INFO] [IntroscopeAgent.SqlParamAgent] Configured max sql PARAM string length at 100