SQL aggregation in PurePath view

[Julius_Loman]

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.

[skrystosik]

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

Sebastian

[Julius_Loman]

Capturing of bind variables does not have any effect. It does not matter if it is turned on or off.

[skrystosik]

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

[Julius_Loman]

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.

[skrystosik]

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