Searching for purepaths with more than one specific database query

[AntonioSousa]

I have a certain type of pages where one, and only one, SQL request query should be executed.

There are cases though, where a Purepath has more than one of those invocations. One example is shown in the image below, where orange are things that I'm hiding, and blue are the same SQL invocation, that in this case is being invoked 3 times, instead of only one:

Now, I'm trying in Dynatrace to find these examples. I have tried backtraces, MDAs, distributed traces with filters, service flows, but had no luck... Any ideas?

[Romanenkov_Al3x]

It is a very interesting task.

For my service I can catch such requests (as I know that in normal for example for "/pets/new.html" expected only 2 Database calls.

Maybe you have the same behavior for "Jboss call".

Number of calls to databases:4-10 

Sorry if I miss understand the problem.

Regards,

Romanenkov Alex

[AntonioSousa]

@Romanenkov_Al3x,

In reality, my Purepaths have many more queries. What I'm looking for is a way to determine a certain amount of a specific query, and not the amount of the total queries...

[paolo_fumanelli]

I'm afraid there is no way to achieve that 😞