AppD Archive

How do I configure db tuna reports?

CommunityUser
Splunk Employee
Splunk Employee

To tell me the most frequently used SQL queries and the worst performing queries?

0 Karma

Arun_Dasetty
Super Champion

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

http://appsphere.appdynamics.com/t5/forums/postpage/category-id/Discussions/choose-node/true/interac...

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

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...