cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Custom extension for Databases

nikhil
Visitor

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

6 REPLIES 6

nikhil
Visitor

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

AntonPineiro
DynaMight Guru
DynaMight Guru

Hi,

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

Best regards

❤️ Emacs ❤️ Vim ❤️ Bash ❤️ Perl

PacoPorro
Dynatrace Leader
Dynatrace Leader

Mike_L
Dynatrace Guru
Dynatrace Guru

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

Mike
Dynatrace provides you with a framework that you can use to extend your observability into data acquired from a database using SQL queries against our supported databases such as Oracle, SQL Server, IBM, MySQL, PostgreSQL, SAP Hana, or Snowflake. Watch this hands-on tutorial where Vagiz Duseev ...

nikhil
Visitor

Thank you all, got exactly what I wanted.

Esam_Eid
Pro

Screenshot_1.jpg

Featured Posts