topic How can we get parameter values passed in monitored database service calls ? By default it shows '?'. in Open Q&A

How can we get parameter values passed in monitored database service calls ? By default it shows '?'.

bhandariviv1 — Tue, 16 Jan 2024 14:45:38 GMT

Hi Memebrs,

When checking details of stored procedures which are called, we get the names but the arguements passed into it, are shown as '?'

A snip is attached for more clarity.

Please suggest something to replace them with actual values passed.

Regards

Vivek

Re: How can we get parameter values passed in monitored database service calls ? By default it shows '?'.

franz_soengen — Mon, 16 Oct 2023 14:57:17 GMT

Hi Vivek,

by default, Dynatrace doesn't capture bind value data because this creates large amounts of data. There is a feature for troubleshooting purposes in beta though: https://community.dynatrace.com/spaces/483/dynatrace...

Its "troubleshooting purposes" because you'll get all bind values and can't make configuration to only catch specific values for now. A configurable feature is on the long term road map.

You can contact your sales representative to enable this beta feature for your environment.

Please note that this is only available for Managed currently.

Edit: Seems like this feature is already GA with OneAgent 151 for .NET, Java and PHP: https://www.dynatrace.com/news/blog/oneagent-activ...

best regards

Franz

Re: How can we get parameter values passed in monitored database service calls ? By default it shows '?'.

bhandariviv1 — Wed, 12 Sep 2018 14:07:14 GMT

Thanks for the update Franz.

Will check on this and update the thread if

something else comes up regarding the same.

Great Help !

Regards

Vivek