To tell me the most frequently used SQL queries and the worst performing queries?
Hi,
Thanks for writing to appsphere community forum, We understood that you are referring to Appdynamics for database let us know if any disconnect,
- Under db tuna home page , under "Your Monitored Databases" section -> Click the database -> Click Activity tab, and under section "Displayed rows :<count>", Click the column "Elapsed" to get the worst sql queries executed on the selected database.
- Currently we can retrieve frequently executed sql query type but could not retrieve the number of time particular query type is executed, please let us know if that helps:
Select Statistics tab -> under "Activity" -> hover over the graph to see the count of queries categorized under select, update, delete and insert for the selected time period
refer docs: http://docs.appdynamics.com/display/ADDB/Reports#Reports-TopSQLbyTypeReport
Do let us know if that helps.
On a side note, we request you raise your queries using form at
and select appropriate board option while posting query (say: appd pro, lite etc, instead community feedback as raising problem queries under this section will not get notified to appsphere support team)
Thanks,
Arun