My customer is asking if there is a way to see the variables inside the SQL transaction, without going through the Tree View in the Tracer. The reason for this is, the customer application has hundreds of components nested inside the tracer, and they will want to be able to see quickly which SQL statement had the performance issue.
Do you have any suggestions?
>> variables inside the SQL transaction, without going through the Tree View in the Tracer.
Can you give us an example or send us a screenshot, if possible?
The only I can think of is using:
a) Historical Query viewer:
Query Stored Events - CA Application Performance Management - 10.7 - CA Technologies Documentation
b) CLWorkstation to extract specific data from traces
CLW Command Reference - CA Application Performance Management - 10.7 - CA Technologies Documentation
You might need to customize the outlook to obtain the information you need
I hope this helps,
Sure, I am refering to this
I see, as far as I know we don't have a way to filter that information.
I don't have a test app with similar properties, but you can try using historical event viewer
If you have 10.7 Java agents, the feature exists, but you have to turn it on.
If you're running < 10.7, you'll need to request a copy of the SQLQueryParams fieldpack from support and add it to your Java agent installation.
I thought it was about exporting those values, sorry, you can use this
Configure SQL Parameter Monitoring - CA Application Performance Management - 10.7 - CA Technologies Documentation
I already have the 10.7 Java agent installed and the rawsql parameter enabled. What I need is to find an easier way to display this information for my customer. As I explained, the variables are visible in the Tracer via the Tree View, but my customer doesn't want to go through hundreds of components to identify the SQL transaction.
Right, that is what I understood, I can't find a way to extract that data from the Tx property and I believe you are looking for a summary report like this:
SQL with variables:
..Select 1 from dualSelect 2 from ***select 3 from yyy..
Maybe you can try to use CLWorstation or APMSQLserver, filter only dynamic sqls and/or the specific ones and then use awk/sed to extract the information as you need to