Query monitoring on Extensions 2.0

[tainabp]

Custom Database Queries got deprecated and now we have the Extensions 2.0 but I'm not being able to monitor some query results with this extention.

Does anyone have a tip on how to do it? 

[dannemca]

You better be ready to create your own Extension for this:

https://community.dynatrace.com/t5/Extensions/Custom-Query-Extension-2-0-Can-I-borrow-yours/td-p/230...

[dannemca]

Here's what worked for me:

I was able to replicate the Custom Query DB extension from 1.0 to 2.0 after Dynatrace updated their docs.

Here are the pages I have used that helped me achieve this:

How to deploy your first extension using VSCode: https://developer.dynatrace.com/extensions-v2/dynatrace-extensions-vscode/guides/getting-started/

Sample Yaml to run DB queries: https://docs.dynatrace.com/docs/extend-dynatrace/extensions20/data-sources/sql/sql-reference

It was quite simple to be fair. I have not yet tested in production, but at least now I have the proper guidance.

[Mike_L]

In the next month or so we're going to release an observability clinic Youtube video on how to do this as well. Good to hear that you managed yourself!

[Mike_L]

The step by step video just came out: https://youtu.be/t9kHPKL9yKY?si=a4EI_F48Kd5Bga29

[Miguel_RinconG · Accepted solution]

Hi Taina,

I recommend you can download and study the last version the Microsoft SQL Server.