Archive

cancel
Showing results for 
Search instead for 
Did you mean: 

Database Agent Is Not Showing Queries

Highlighted
Creator

Database Agent Is Not Showing Queries

Hi,

I am using AppDynamics with AppAgent and DBAgent and It seems that everything runs well. For collecting data I'm using the controller as a SaaS.

Everything is OK except the db queries. When I go to the database panel (AppDynamics) and I go to the Queries tab it does not show any result. However if I go to the database dashboard it shows the number of queries.

What could be happening with the queries?

I need it to make load and stress tests.

Thanks!!!

Tags (2)
Database Agent Is Not Showing Queries
5 REPLIES
Employee

Re: Database Agent Is Not Showing Queries

Hi,

 

Please provide screenshots from saas UI and also attach archive version of <dbagent_dir>/logs folder for our initial review ? to assist you further on this

Creator

Re: Database Agent Is Not Showing Queries

There are many screenshots and the log file.

 

If you need something else I will be here.

 

Thx!!

Employee

Re: Database Agent Is Not Showing Queries

Hi,

 

We do not see any specific errors in logs , Can you try belo if possible as we see this could be due to there is no sql that is taken >= 0 secs as we see total time spent on db is 00:00:00 as per screenshot:

 

a) issue an sql query on monitored DB server that will take around 1-2 secs

 

b) check in UI after 15 minutes with 1 hour time selected once

Creator

Re: Database Agent Is Not Showing Queries

This means that it does not show queries which running time is less than 1 second?

Employee

Re: Database Agent Is Not Showing Queries

Hi,

 

The suggested step was requested to make sure there is some load on db server by manually issuing query as we do not see any errors in logs , Hope that answers