Querying to find the most costly ingested metrics

[siavash1996]

Hi there,

I'm trying to find a way to query grail to find the most expensive metrics that we are ingesting via API. In Gen2, it was pretty easy to get an idea of the cost of custom metrics, but I have been unable to find any way of doing it for the new Gen3 Grail-enabled metrics. I know it is usually a function of cardinality and the number of metric points, but I want to be able to target specific expensive custom metrics to reduce their ingestion if possible and reduce cost. Only problem is I don't know which of our ingested metrics to look at first.

If I run a DQL query for "metrics", none of the returned columns seem to have anything that would be useful for estimating cost.

[AntonPineiro]

Hi,

We have a section in the Account level where you can find notebooks about this.

Best regards

[siavash1996]

Maybe I'm not seeing clearly, but the notebook that is linked in the Account portal doesn't seem to have any queries that split upon the metric key.

[AntonioSousa]

@siavash1996 ,
Dynatrace took it away. It was the Consumption in the menu.

There still is a metric where you can get part of that information, available through Data Explorer:

• builtin:billing.custom_metrics_classic.raw.usage_by_metric_key:splitBy(metric_key):sort(value(auto,descending))

Unfortunately, this metric is not supported in Grail, at least that I know of...

[siavash1996]

Thanks for confirming that. I should probably submit a product idea for this then.