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?
@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
Heard requests like that at a few customers, and although it’s possible via plugins, having this directly in synthetic would be a lower barrier of entry.
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:
“can easily be containerized” sounds good, too - although for me not so easy to do atm… If anyone can share an OpenShift build config, docker compose file or even a deployable docker image that would be awesome…