SQL Server extension make calls less frequently

[crp_dyna]

We are using SQL server extension to monitor SQL server databases.
The extension has metrics to monitor the SQL Server databases. These metrics makes call every minute to SQL server databases. What we have noticed is that by middle of the month we have consumed all our DDU's

Is it possible to change the frequency of these metrics to run every 5 minutes or 10 minutes ?
I believe this requires change to yaml file but I am not sure what to change.

[JamesKitson]

Normally, that is correct. To change the frequency for the latest released extension you would need to adjust it in the yaml (there are 'frequency' fields setting it to the default once per minute). Changing the yaml means having to change the extension name and resigning it with a custom certificate though.

However, I believe that the ability to configure this via a monitoring configuration variable will be available very soon (I think mid-February around when 1.307 is available) so I would just wait for this new version.

[crp_dyna]

Thank You James
Where does the monitoring configuration variable goes ? I am new to Dynatrace and was wondering how do i configure the variable ? Is it through Dynatrace console ?

[JamesKitson · Accepted solution]

It is not exposed as a configuration variable currently, so you won't see this now. It will be fields you can enter values in when setting up the monitoring configuration once it is added/released.

https://docs.dynatrace.com/docs/shortlink/extension-yaml#variables

[crp_dyna]

Hello James

I have downloaded the latest SQL Server extension 2.10 version.
How do I change the metric where it makes the call to the SQL Server to 5 minutes rather than 1 minute. If you can provide where I should make the update to the yaml file and install it to Dynatrace hub 

[JamesKitson · Accepted solution]

This is exposed in the configuration in the latest version. You can control the query intervals by setting these values:

So there should be no need to make a custom version and change the yaml. However, if you ever need to this is documented here: https://docs.dynatrace.com/docs/shortlink/sql-reference#interval