topic Query monitoring on Extensions 2.0 in Extensions

Query monitoring on Extensions 2.0

tainabp — Wed, 31 Jan 2024 18:19:54 GMT

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?

Re: Query monitoring on Extensions 2.0

dannemca — Wed, 31 Jan 2024 18:59:04 GMT

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/230751

Re: Query monitoring on Extensions 2.0

dannemca — Thu, 29 Feb 2024 16:59:14 GMT

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.

Re: Query monitoring on Extensions 2.0

Mike_L — Thu, 29 Feb 2024 17:35:08 GMT

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!

Re: Query monitoring on Extensions 2.0

Miguel_RinconG — Thu, 29 Feb 2024 19:04:54 GMT

Hi Taina,

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

Re: Query monitoring on Extensions 2.0

Mike_L — Fri, 01 Mar 2024 20:30:55 GMT

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