cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Searching for purepaths with more than one specific database query

AntonioSousa
DynaMight Guru
DynaMight Guru

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:

AntonioSousa_0-1674509598877.png

 

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?

Antonio Sousa
3 REPLIES 3

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

Romanenkov_Al3x_0-1674513098478.png

Number of calls to databases:4-10 

Romanenkov_Al3x_1-1674513240648.png

Sorry if I miss understand the problem.

Regards,

Romanenkov Alex

 

 

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

Antonio Sousa

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