DX Application Performance Management

Expand all | Collapse all

Search by high consumption Queries ( Top 10 Introscope )

  • 1.  Search by high consumption Queries ( Top 10 Introscope )

    Posted 01-13-2016 07:05 PM

    Hello everyone! Could you help me; I need check for high consumption of queries in Instrocope 10 , I tried using the expression senguinte ( // this is a top 10 query select * from metric_data where agent='.*' and metric='.*Average Response.*' and timestamp between '2016/01/12 00:00:00' and '2016/01/12 23:59:00' sort by value d maxmatches=10 ) did not have more success.

    Do you know any expression that can help me?



  • 2.  Re: Search by high consumption Queries ( Top 10 Introscope )

    Broadcom Employee
    Posted 01-13-2016 10:29 PM

    Hello Ricardo,

    It looks like you have a valid query syntax for Introscope JDBC API:

    JDBC API - CA Application Performance Management - 10.1 - CA Technologies Documentation

    However there may be a problem with your date format not matching your JVM locale. This KB has advice on that:

    http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec604018.aspx

     

    For more on thios topic:

    There is also Web Service Fieldpack from Guenter_Grossberger which has a war file you can deploy to the EM_HOME/webapps folder to be hosted by the EM Web Server. Then use the jsp directly or Excel for your queries. You can find it on this Documents link: Easy Integration Web Service Fieldpack

    Also the Easy Integration Kit from Hiko_Davis here Re: RE: Introscope JDBC API - Performance

     

    Hope it helps

     

    Regards,

     

    Lynn



  • 3.  Re: Search by high consumption Queries ( Top 10 Introscope )

    Posted 01-15-2016 11:42 AM
    Hi! Thanks for the tips! I'll be checking

    Att
    Ricardo Vieira


  • 4.  Re: Search by high consumption Queries ( Top 10 Introscope )

    Broadcom Employee
    Posted 01-14-2016 08:31 AM

    Hi Ricardo:

    Please respond if the previous answer was helpful or if further assistance is needed.

     

    Thanks

    Hal German



  • 5.  Re: Search by high consumption Queries ( Top 10 Introscope )

    Posted 01-15-2016 11:35 AM

    Hi! I still can not solve can help me ?
    I have a problem that is this , I must look with the Instroscope for queries that consume CPU , I 've been using the following command
    ( . *) SELECT ( . * ) Average Response Time ( . *)

    You know some search commands in Introscope ?

     

    Att

    Ricardo Vieira



  • 6.  Re: Search by high consumption Queries ( Top 10 Introscope )

    Broadcom Employee
    Posted 01-15-2016 12:10 PM

    Hi Ricardo:

       Including Lynn_Williams  to see if he has some additional suggestions

    Thanks

    Hal German



  • 7.  Re: Search by high consumption Queries ( Top 10 Introscope )

    Broadcom Employee
    Posted 01-17-2016 05:29 PM

    Hi Ricardo.

    For the metric expression part of the query.

    Instead of:

    (.*)Average Response Time(.*)

    try:

    (.*)CPU Time(.*)

     

    Hope it helps

     

    Regards,

     

    Lynn



  • 8.  Re: Search by high consumption Queries ( Top 10 Introscope )

    Posted 01-14-2016 07:16 PM

    Hi! OK! I will check the tips ... Thanks for now ! I used the expressions most did not succeed . I can only collect the queries with the command

    (.*)SELECT(.*)Average Response Time(.*)

    More 'll evaluate better

     

    Att

    Ricardo L P Vieira