topic Re: database statements sometime with parameters sometimes with out in Open Q&A

database statements sometime with parameters sometimes with out

Yosi_Neuman — Wed, 06 Mar 2019 15:07:39 GMT

Hi guys,

Customer asks why from modifications dynatrace not list the parameters as it does for queries

modifications

queries

and its not because there are no parameters for example pp of one of the insert:

Any Ideas?

Yos

Re: database statements sometime with parameters sometimes with out

ChadTurner — Tue, 21 Apr 2020 14:17:01 GMT

I've reach out to Support who stated "when it comes to sql transactions we don't show this detail because potentially there could have been hundreds of changes made in the commit, and it's just something that is not scaleable if we showed this level of detail" and thats why you dont see the statement data at the modification level.

Re: database statements sometime with parameters sometimes with out

Domenico_Bressi — Tue, 21 Apr 2020 22:30:02 GMT

If you need you can activate the "Bind option" (disable by default) but this will introduce:

- possible GDPR issue. All parameter are captured in "clear" no more [ ?,?,? ]. Personal data inside SQL

- Query are aggregated (performance) by different parameters inside

- overloading on Cluster and monitored application.

Be clear with customer about the impact (and if really need it)

https://www.dynatrace.com/support/help/how-to-use-dynatrace/databases/introduction/support-for-sql-bind-variables/