In good old AppMon there existed the DB Query Monitor plugin which could be used to send an arbitrary SQL query against a database at scheduled intervals and derive various measures from it (row count, response time etc.).
Question: Is there an equivalent capability or plugin available for Dynatrace which could be used to run SQL queries at scheduled intervals (say: hourly) either from an ActiveGate or a OneAgent and derive metrics such as row count and response time from it? Kinda like a synthetic monitor, only for simulating DB clients 🙂If there isn't anything available out-of-the-box or as an optional plugin: Would this be a project worth pursuing as a self-written Python plugin to run on OneAgents?
Any feedback would be greatly appreciated.
Solved! Go to Solution.
There is none yet that I know of.
Would be a good way to get started with dynatrace plugins. You could use a Active Gate Plugin for that aswell.
@Patrick H. and @Dave M. are right, you can create a plugin. What we have on our road map are "custom monitors" which enrich our Synthetic use case to additional protocol checks like pings, trace route or ldap checks. I can't give you a date when we will be ready ... but it will not be in the next 6 months 😉
Thanks for the feedback!
Regarding the custom plugin approach: What's limiting in our case is that the execution interval is hard-coded to be 1 min and can't be changed...
Is this still the case for the latest version? And if so, is there something on the roadmap for allowing more flexibility?
Not sure if this still an actual case, however we developed a rather experimental plugin, which does not rely on OneAgent or ActiveGates but using the 3rd Party Synthetic API and pythons APScheduler to exectue SQL Queries regulary:
give this a try - did not test the functionality of the app itself but at least the API is reachable
you could play around with passing the env variables through the dockerfile, I'll update the repo next week with a fully tested dockerfile
as mentioned on the answer above,
Check out this repo:
Its using the 3rd party synthetic API, flask to add/remove synthetic
SQL queries and APScheduler to execute them at the defined intervals.