18 Oct 2023 09:28 AM - edited 18 Oct 2023 09:29 AM
In this Observability Clinic with Andi Grabner @andreas_grabner, Fabrice Courbon @fcourbon, Principal Product Manager at Dynatrace, explains the core principles behind metrics and timeseries data. To showcase the power of DQL for Metrics, Fabrice walks us through several DQL Metrics Use Cases, such as getting resource utilization of your K8s clusters, available disk storage of hosts with specific tags, or calculating SLOs based on a variety of timeseries data.
Links discussed during this session:
A Practical Guide to DQL
DQL timeseries command
DQL timeseries examples: https://dynatr.ac/3PHFXoZ
Built-in Metrics in Grail: https://dynatr.ac/45nBLk1
The link to Notebook will be available on this GitHub Repo
Chapter List:
00:00 - Introduction
00:43 - What you'll learn today
01:36 - What is Grail
03:22 - Anatomy of a time series
08:55 - Time and space aggregation
11:52 - DQL timeseries command
15:40 - DEMO
51:00 - Wrap Up
The recording is available also on the Dynatrace University: LINK
- - -
Subscribe to our YT channel
Stay up-to-date with Dynatrace! Follow us on Facebook, Instagram, LinkedIn, Twitter, Twitch
01 Dec 2023 05:01 PM
So the metrics in DQL are driving me a bit nuts. Why isn't there an option to return timestamps along with the values? The way it seems to work is to return a timeframe and an interval and I assume there's a script in Dynatrace that takes the start and end timeframes from the result and creates timestamps based on the values when charting it.
The problem is, when querying this data via the API in something like Grafana, I can't chart this data. Grafana doesn't have a built-in function to generate timestamps from a time range and interval values...
Why not just give us an option to return traditional timestamps with the values? You know, like pretty much every other API (including the Dynatrace Metrics API v1 and v2) on the planet?
If this is currently possible, I don't see any example of how to do this in the documentation nor in any example I've seen.
07 Dec 2023 08:33 AM
The timestamps are entirely defined by the timeframe start and end + the interval fields provided in the DQL results. In the future, DQL will have generic functionality to map/generate series out of other series, which will allow it to also generate those timestamps.
25 Jul 2024 03:14 PM
That's great to hear. I hope this is implemented soon. We found a way to do it in Grafana using the Infinity plugin and a crazy UQL and JSONata script. It is very inconvenient though and prone to performance issues for large metric queries.