Transaction with highest SQL queries

[Wayne.Gibson]

Hi,

New to AppDynamics

I was curious if it was possible to create a dashboard or query to identify which endpoints were performing the most number of SQL queries.

Thanks

Wayne

[Hiroki.Ito]

Hi @Wayne.Gibson ,

Thank you for posting to the community.

Unfortunately, it is not possible to create a dashboard to identify which business transactions/endpoints are performing the most number of SQL queries.

The data is not a simple database metric and is not available to be plotted in a custom dashboard.

However, if you use Java or PHP Application, Database Business Transactions Window in Databases tab shows you business transactions ranked by their cumulative execution time on the database.

You can click each transaction to see the queries run in that particular transaction.

https://docs.appdynamics.com/21.6/en/database-visibility/monitor-databases-and-database-servers/moni...

Best Regards,

Hiroki