question

Julius L. avatar image
Julius L. asked ·

SQL aggregation in PurePath view

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.

databasepurepath
purepath-sql.png (23.8 KiB)
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Sebastian K. avatar image
Sebastian K. answered ·

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

Sebastian

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Julius L. avatar image
Julius L. answered ·
Capturing of bind variables does not have any effect. It does not matter if it is turned on or off.
2 comments Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

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

0 Likes 0 · ·

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.

0 Likes 0 · ·
Sebastian K. avatar image
Sebastian K. answered ·

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

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Space Topics