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

database statements sometime with parameters sometimes with out

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


2 REPLIES 2

ChadTurner
Leader

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.

-Chad

Domenico_Bressi
Advisor

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.