DX Application Performance Management

Expand all | Collapse all

How to see SQL queries without using the Tracer?

Jump to Best Answer
  • 1.  How to see SQL queries without using the Tracer?

    Posted 11-28-2018 08:33 AM

    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.



  • 2.  Re: How to see SQL queries without using the Tracer?

    Posted 11-28-2018 08:46 AM

    Dear Community:'

    Do you have any suggestions?

    Thanks

    Hal German



  • 3.  Re: How to see SQL queries without using the Tracer?

    Posted 11-28-2018 09:44 AM

    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



  • 4.  Re: How to see SQL queries without using the Tracer?

    Posted 11-28-2018 09:57 AM

     

    Sure, I am refering to this

     



  • 5.  Re: How to see SQL queries without using the Tracer?

    Posted 11-28-2018 12:27 PM

    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



  • 6.  Re: How to see SQL queries without using the Tracer?

    Posted 11-28-2018 12:31 PM

    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.



  • 7.  Re: How to see SQL queries without using the Tracer?

    Posted 11-28-2018 12:40 PM

    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 



  • 8.  Re: How to see SQL queries without using the Tracer?

    Posted 11-29-2018 03:41 AM

    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. 



  • 9.  Re: How to see SQL queries without using the Tracer?
    Best Answer

    Posted 11-29-2018 05:03 AM

    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