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

SQL aggregation in PurePath view

Julius_Loman
Leader

Can someone explain the circumstances when Dynatrace aggregates SQL queries at PurePath view?



So far I was not able to find when this aggregation happens and when not. Even if the application executes same prepared statement multiple times sequentially (no matter if it is the same prepared statement Java object or not) I see this non-aggregated for one application (not the example above). In another application, Dynatrace aggregates the queries even if they are not performed sequentially.


TEMPEST a.s., Slovakia, Dynatrace Master Partner
5 REPLIES 5

Do you have enabled capturing bind values for part of process groups? In such case this can be reason.

Sebastian


Julius_Loman
Leader
Capturing of bind variables does not have any effect. It does not matter if it is turned on or off.
TEMPEST a.s., Slovakia, Dynatrace Master Partner

Actually it has because when it is turned off aggregation is disabled. In other way you will not have captured parameters for each statements, the same was in Appmon.

Sebastian


I have environments where bind variables capture is on and I have aggregated queries. (bind variables are collected for each execution).

I also have environments where bind variables capture is not available (SaaS) or not enabled (Managed) and I also get aggregated queries.


TEMPEST a.s., Slovakia, Dynatrace Master Partner

One more idea, for environment where you have not agregated statements do you have get connect before each instance? Only idea I have is binding the same statements that are using same connection.

Sebastian