topic Re: custom db extension in Extensions

Custom extension for Databases

nikhil — Fri, 10 May 2024 13:53:57 GMT

hi all,

I am new to dynatrace and working on custom query extension. I want SQL query to execute at 1min interval and provide the metrics. From VS code i deployed the custom extension. Beyond that what is the format to add query to yaml file and start monitoring ?

requirement:

need to get the metrics for following SQL query

select * from (select sql_text, elapsed_time/1000000 from sys.v_$sqlarea order by 2 desc) where rownum < 21;

Please help me out. Thanks

Re: custom db extension

nikhil — Thu, 11 Apr 2024 00:19:37 GMT

If someone has the custom query extension yaml file with SQL query monitored, pls provide to use it as template

Re: custom db extension

AntonPineiro — Thu, 11 Apr 2024 06:41:07 GMT

Hi,

You have a SQL data source reference. It might be helpful.

Best regards

Re: custom db extension

PacoPorro — Thu, 11 Apr 2024 06:44:07 GMT

Have you tried the doc skeleton?
https://docs.dynatrace.com/docs/shortlink/sql-reference#data-scope

Re: custom db extension

Mike_L — Thu, 11 Apr 2024 07:24:16 GMT

On top of the other links people already shared, I recommend this video for a step by step guide: https://youtu.be/t9kHPKL9yKY?si=14TdHzlQQMoVLZ3g

Re: custom db extension

nikhil — Thu, 11 Apr 2024 12:12:00 GMT

Thank you all, got exactly what I wanted.

Re: custom db extension

Esam_Eid — Thu, 11 Apr 2024 12:12:13 GMT

Re: custom db extension

wwangwrk — Wed, 25 Jun 2025 17:14:42 GMT

Is it possible to define a variable for the interval (10 minutes) and use it in the query?