DX Application Performance Management

Hello,

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.

Dear Community:'

Do you have any suggestions?

Thanks

Hal German

Hi  Gheorghe,

>> 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,

Sergio

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

I thought it was about exporting those values, sorry, you can use this

introscope.agent.sqlagent.rawsql

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 dual
Select 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

I hope this helps,

Sergio