database statements sometime with parameters sometimes with out

[Yosi_Neuman]

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

[ChadTurner · Accepted solution]

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.

[Domenico_Bressi · Accepted solution]

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

Br

M.