11 Apr 2024
01:16 AM
- last edited on
10 May 2024
02:53 PM
by
Michal_Gebacki
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
Solved! Go to Solution.
11 Apr 2024 01:19 AM
If someone has the custom query extension yaml file with SQL query monitored, pls provide to use it as template
11 Apr 2024 07:41 AM
Hi,
You have a SQL data source reference. It might be helpful.
Best regards
11 Apr 2024 08:24 AM
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
11 Apr 2024 01:12 PM
Thank you all, got exactly what I wanted.