View DB Call Values

Question

Question by George B. · May 07, 2013 at 09:49 PM ·

View DB Call Values

Again, sorry for probably a simple question, but how can I capture (view) the values in a database call rather than just seeing the (?,?,?,?,?,?) values?

Thanks,
George

0

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 1 · 2013-05-08T04:17:55Z

Answer by George B. · May 08, 2013 at 04:17 AM

Perfect. Thanks!

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 2 · 2013-05-07T22:18:36Z

Answer by Zajac W. · May 07, 2013 at 10:18 PM

Hi George,

If you have enabled bind value capturing, you should be able to see these values by right clicking on this query and selecting "Details".

If you do not see these values you will need to enable this by going into the system profile -> expand the agent group associated with this query -> select "Sensor Configuration" -> Select Properties next to the JDBC (For Java) or ADO.NET (For .NET) -> and check the "Enable bind value capturing"

Also, if you would like to see these values in the database dashlet, you can do so by clicking on the "Enable bind variables" icon:

Hope this helps!

EDIT: NOTE: This does add overhead and should only be used when needed.

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

View DB Call Values

2 Replies

Join the conversation!

NAM 2019 SP3 is available

LIVE WEBINAR

Follow this Question

Forum Tags