cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Report on most expensive queries

greg2
Newcomer

Hello,

Is it possible to have a report showing the most time consuming queries made on the system?

I came across a query which would take 500ms, the query would run between 4 to 10 times depends on user settings, resulting in a bad response time. This did help to detect missing indexes on the DB.

Thanks

Greg

2 REPLIES 2

michael_kopp
Dynatrace Pro
Dynatrace Pro

Hi @Gregory B.,

Yes it is go to the database service that you are interested in, in the service list. Click the View all database statements button. In the resulting Database activity screen, simply click the Response time median vs slowest 10% column. The list will then show the slowest database statements. Does that help?

greg2
Newcomer

Michael,

Thank you for this answer. I knew you would have that somewhere. That will help.

Gregory