Search by high consumption Queries ( Top 10 Introscope )

[ricardosp_br]

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?

[Lynn Williams]

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

[ricardosp_br]

Hi! Thanks for the tips! I'll be checking

Att
Ricardo Vieira

[Hallett German]

Hi Ricardo:

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

 

Thanks

Hal German

[ricardosp_br]

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

[Hallett German]

Hi Ricardo:

   Including Lynn_Williams  to see if he has some additional suggestions

Thanks

Hal German

[Lynn Williams]

Hi Ricardo.

For the metric expression part of the query.

Instead of:

(.*)Average Response Time(.*)

try:

(.*)CPU Time(.*)

 

Hope it helps

 

Regards,

 

Lynn

[ricardosp_br]

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