Creating Custom Metric For Database Queries

kasdev — Thu, 16 May 2024 19:24:55 GMT

Hello. I want to see database queries via custom metric if its possible. Anyone has an idea for how to achieve it?

Re: Creating Custom Metric For Database Queries

PierreGutierrez — Thu, 16 May 2024 22:17:24 GMT

Hi @kasdev

I think what you are looking for is this : Solved: Custom extension for Databases - Dynatrace Community
I suggest checking the link because it has many very good answers.

But in summary what you need to do is create a metric from "custom database extension", choosing the database of your preference.
Custom database extension monitoring & observability | Dynatrace Hub

Dynatrace provides you with documentation ( https://docs.dynatrace.com/docs/shortlink/sql-datasource) and a very good video so you can learn how to do it ( https://youtu.be/t9kHPKL9yKY?si=14TdHzlQQMoVLZ3g).

---------------------------------------------------------------------------------------

Once you get the metrics in dynatrace, you could exploit that information in Dashboard Generation 3:
I share an example code with you:

import { metricsClient, monitoredEntitiesClient } from "@dynatrace-sdk/client-classic-environment-v2"; async function fetchMetrics(metricSelector, from,to) { const response = await metricsClient.query({ acceptType: 'application/json; charset=utf-8', from: from, to: to, metricSelector: metricSelector }); return response; } export default async function () { let sum = 0; let from = Date.parse(new Date($dt_timeframe_from)).toString(); let to = Date.parse(new Date($dt_timeframe_to)).toString(); let query_data = 'builtin:apps.other.keyUserActions.requestCount.os:splitBy("dt.entity.os"):sort(value(auto,descending)):limit(20)'; let data = await fetchMetrics(query_data,from, to); }

In JavaScript example : The query_data line, you have to replace it with the metric you have created

I hope it's helpful 💪

topic Creating Custom Metric For Database Queries in DQL

Creating Custom Metric For Database Queries

Re: Creating Custom Metric For Database Queries