<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic DQL costs when querying spans – looking for advice in DQL</title>
    <link>https://community.dynatrace.com/t5/DQL/DQL-costs-when-querying-spans-looking-for-advice/m-p/296885#M3233</link>
    <description>&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P class=""&gt;&lt;SPAN&gt;Hi everyone,&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=""&gt;&lt;SPAN&gt;I’m looking for advice on managing and controlling query costs in DQL, especially when working with spans.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=""&gt;&lt;SPAN&gt;In my recent experiments, I’ve been querying spans for about 1–2 hours, even with a 500GB limit in a notebook, and I’ve already incurred more than €70 in costs. At that rate, this could scale to roughly €25K per year, which feels quite high for platform usage. Therefore I'm guessing there is a better way to achieve certain informational needs.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=""&gt;&lt;SPAN&gt;I’d love to understand how others are handling this more efficiently. Specifically:&lt;/SPAN&gt;&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;&lt;SPAN&gt;What are best practices to control or reduce query costs when working with spans?&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI&gt;&lt;SPAN&gt;Do you rely on approaches like pre-aggregation (e.g., creating metrics or business events) instead of querying raw spans?&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI&gt;&lt;SPAN&gt;How do you structure or use buckets to reduce the amount of data scanned?&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI&gt;&lt;SPAN&gt;Are there recommended strategies for limiting data (time ranges, filters, sampling, etc.)?&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI&gt;&lt;SPAN&gt;How do you monitor and optimize expensive queries effectively? Do we need to create anomaly detectors?&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI&gt;&lt;SPAN&gt;Any insights, patterns, or real-world examples would be greatly appreciated.&lt;/SPAN&gt;&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&lt;SPAN&gt;Thanks in advance!&lt;BR /&gt;&lt;BR /&gt;Michiel&lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Tue, 31 Mar 2026 06:13:41 GMT</pubDate>
    <dc:creator>michiel_otten</dc:creator>
    <dc:date>2026-03-31T06:13:41Z</dc:date>
    <item>
      <title>DQL costs when querying spans – looking for advice</title>
      <link>https://community.dynatrace.com/t5/DQL/DQL-costs-when-querying-spans-looking-for-advice/m-p/296885#M3233</link>
      <description>&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P class=""&gt;&lt;SPAN&gt;Hi everyone,&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=""&gt;&lt;SPAN&gt;I’m looking for advice on managing and controlling query costs in DQL, especially when working with spans.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=""&gt;&lt;SPAN&gt;In my recent experiments, I’ve been querying spans for about 1–2 hours, even with a 500GB limit in a notebook, and I’ve already incurred more than €70 in costs. At that rate, this could scale to roughly €25K per year, which feels quite high for platform usage. Therefore I'm guessing there is a better way to achieve certain informational needs.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=""&gt;&lt;SPAN&gt;I’d love to understand how others are handling this more efficiently. Specifically:&lt;/SPAN&gt;&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;&lt;SPAN&gt;What are best practices to control or reduce query costs when working with spans?&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI&gt;&lt;SPAN&gt;Do you rely on approaches like pre-aggregation (e.g., creating metrics or business events) instead of querying raw spans?&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI&gt;&lt;SPAN&gt;How do you structure or use buckets to reduce the amount of data scanned?&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI&gt;&lt;SPAN&gt;Are there recommended strategies for limiting data (time ranges, filters, sampling, etc.)?&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI&gt;&lt;SPAN&gt;How do you monitor and optimize expensive queries effectively? Do we need to create anomaly detectors?&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI&gt;&lt;SPAN&gt;Any insights, patterns, or real-world examples would be greatly appreciated.&lt;/SPAN&gt;&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&lt;SPAN&gt;Thanks in advance!&lt;BR /&gt;&lt;BR /&gt;Michiel&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 31 Mar 2026 06:13:41 GMT</pubDate>
      <guid>https://community.dynatrace.com/t5/DQL/DQL-costs-when-querying-spans-looking-for-advice/m-p/296885#M3233</guid>
      <dc:creator>michiel_otten</dc:creator>
      <dc:date>2026-03-31T06:13:41Z</dc:date>
    </item>
  </channel>
</rss>

