https://community.splunk.com/t5/Splunk-AppDynamics/Transaction-with-highest-SQL-queries/m-p/729235#M6584 <P>Hi,</P><P>New to AppDynamics <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>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.</P><P>Thanks</P><P>Wayne</P> Fri, 23 Apr 2021 13:54:08 GMT Wayne_Gibson 2021-04-23T13:54:08Z https://community.splunk.com/t5/Splunk-AppDynamics/Transaction-with-highest-SQL-queries/m-p/729235#M6584 <P>Hi,</P><P>New to AppDynamics <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>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.</P><P>Thanks</P><P>Wayne</P> Fri, 23 Apr 2021 13:54:08 GMT https://community.splunk.com/t5/Splunk-AppDynamics/Transaction-with-highest-SQL-queries/m-p/729235#M6584 Wayne_Gibson 2021-04-23T13:54:08Z https://community.splunk.com/t5/Splunk-AppDynamics/Transaction-with-highest-SQL-queries/m-p/729236#M6585 <DIV> <DIV><SPAN>Hi&nbsp;<A href="https://community.appdynamics.com/t5/user/viewprofilepage/user-id/150252">@Wayne.Gibson</A>&nbsp;,</SPAN></DIV> <BR /> <DIV><SPAN>Thank you for posting to the community.</SPAN></DIV> <DIV><SPAN>Unfortunately, it is not possible to create a dashboard to identify which business transactions/endpoints are performing the most number of SQL queries.</SPAN></DIV> <DIV><SPAN>The data is not a simple database metric and is not available to be plotted in a custom dashboard.</SPAN></DIV> <BR /> <DIV><SPAN>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.</SPAN></DIV> <DIV><SPAN>You can click each transaction to see the queries run in that particular transaction.</SPAN></DIV> <DIV><SPAN><A href="https://docs.appdynamics.com/21.6/en/database-visibility/monitor-databases-and-database-servers/monitor-database-performance/database-business-transactions-window" target="_blank" rel="nofollow noopener noreferrer">https://docs.appdynamics.com/21.6/en/database-visibility/monitor-databases-and-database-servers/monitor-database-performance/database-business-transactions-window</A></SPAN></DIV> <BR /> <DIV><SPAN>Best Regards,</SPAN></DIV> <BR /> <DIV><SPAN>Hiroki</SPAN></DIV> </DIV> Fri, 25 Jun 2021 04:40:22 GMT https://community.splunk.com/t5/Splunk-AppDynamics/Transaction-with-highest-SQL-queries/m-p/729236#M6585 Hiroki_Ito 2021-06-25T04:40:22Z