topic Re: SQL "VIEW" command in Open Q&A

SQL "VIEW" command

natanael_mendes — Wed, 20 Sep 2023 19:24:59 GMT

How can i see a view statement in dynatrace?

Re: SQL "VIEW" command

AntonPineiro — Wed, 20 Sep 2023 20:31:39 GMT

Hi,

I am not sure if you are asking about this, but you have top database statements in Dynatrace.

Best regards

Re: SQL "VIEW" command

natanael_mendes — Wed, 20 Sep 2023 20:37:21 GMT

but i cant see the "view" statement there

Re: SQL "VIEW" command

Kenny_Gillette — Wed, 20 Sep 2023 21:34:01 GMT

Please review:

https://www.dynatrace.com/support/help/shortlink/release-notes-saas-sprint-275#bind-variable-settings-for-dps-and-adaptive-traffic-management-version-3

Bind variable settings for DPS and Adaptive traffic management Version 3

Application Observability | Distributed traces

Bind variable capturing can be enabled by all accounts using a Dynatrace platform subscription and tenants that are using Adaptive Traffic Management V3. No additional support request is needed.

Re: SQL "VIEW" command

Taylor-Sanchez — Thu, 21 Sep 2023 04:54:08 GMT

Hi @natanael_mendes ,

What exactly do you mean by the 'view' statement, or what specific data are you trying to look for? As @AntonPineiro mentioned, most of the information that you're going to want to be able to analyze is going to be in the top database statements.

Since Dynatrace captures the DB information from the perspective of the application, you'll be able to see specific queries and modifications as well in the 'Database' section of Dynatrace as well.

Drilling down into this might give you further insight into what you're trying to look for.

Cheers,

Taylor S.