Custom extension for Databases

[nikhil]

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

[nikhil]

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

[AntonPineiro · Accepted solution]

Hi,

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

Best regards

[PacoPorro · Accepted solution]

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

[Mike_L · Accepted solution]

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

[nikhil]

Thank you all, got exactly what I wanted.

[Esam_Eid]