AppD Archive

Grouping & Counting identical SQL statements

CommunityUser
Splunk Employee
Splunk Employee

Hi AppDynamics Community,

When selecting two or more Transcation Snapshots and viewing "Most Expensive Methods / SQL Statements" (via Analyze > Identify the most expensive call / SQL statements in a group of Snapshots), is that possible to group identical statements as one?

The attached picture explains better.

I know that 4 selected statements are identical and I would like to count it as 4 (ignoring Time), the same way as viewing SQL Calls of a Call Drill Down of a single transcation snapshot (2 X [select ...).

Thank you.

0 Karma

Arun_Dasetty
Super Champion

Hi Rafael,

We confirm the "exensive sql" section in snapshot comparision popup does not have an option to group similar SQL from across to snapshots either from same BT or from different BT snapshots in controller UI, we do group similar SQL and shows the aggrgated count in "SQL Calls" section but this specific to particular BT snapshot as listed below:

image.png

- check the other screen in which we list top (this section only list TOP 10 SQL/Backend calls for selected backend filters) 

image.png

Check if that information helps.

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 ...