topic Re: Turn off capturing of DB Prepare statements in Open Q&A

Turn off capturing of DB Prepare statements

gilgi — Thu, 25 Jun 2026 07:57:14 GMT

Hi,

While Database prepare statements may be beneficial, I've seen more than once situations in which the DB prepare statements (in an intensive database based application) take a huge percentage of the allowed trace ingest quota for the V3 platform. This results in a customers missing out crucial spans and having to pay for additional storage because of spans they do not want.
My question to you: did you face such situations? how did you handle that? and for the Dynatrace guys our here - do you know of any way to just turn off the prepare statements collection?

Gil.

Re: Turn off capturing of DB Prepare statements

AravindhanV — Fri, 17 Jul 2026 05:32:17 GMT

Hi @gilgi ,

Its Valid question, how about using the Bind Variables,

Understanding would be, Bind variables allow the database server to prepare the statement once and execute it multiple times without reparsing or reanalyzing it.

Settings > Server-side service monitoring > Deep monitoring

Under Database Capture SQL bind values.

Have a look and share your thought

Thanks

Re: Turn off capturing of DB Prepare statements

dylan_taelemans — Fri, 17 Jul 2026 07:27:45 GMT

If you're using Dynatrace SaaS, you could try using OpenPipeline to drop them.

Something similar to this: