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

Top N long running query in AppMon Database Dashboard

yuting_wu
Guide

We would like to create a long running query report. How can we get the Top 1000 long running query in the database hotspot dashlet?


6 REPLIES 6

BabarQayyum
Leader

Hello @Yuting W.

If you add database dashlet and then edit filter the dashlet and choose the Top X for your desired criterion then in the grouping choose Flat and view only the Table.


Regards,

Babar


How do you "choose the Top X for your desired criterion" ? I want to get the automatically.


Hello @Yuting W.

Right-click on the database filter and then you will find the following settings.

Regards,

Babar


Thank you. A follow up question - for the bind value column on the database dashlet, is that for the max running instance of that query?


Hello @Yuting W.

This column appears if the analysis of bind values is enabled.

Have a look at the following link for better understanding:

https://www.dynatrace.com/support/doc/appmon/application-monitoring/appmon-client/dashlets/database-...

Regards,

Babar


Hi Babar,


It is unclear to me on the documentation whether the bind values is for the maximum time running query instance or not.


Yuting