Generic SQL Execution Plugin
I am considering the possibility of developing a generic SQL execution plugin, but I want to know a few things first.
Here is the scenario I have:
In order to determine if a batch processor has been run, I need to execute a stored procedure on a SQL server. The result of this run will tell me if this processing has happened, is still happening, etc. Ideally, I would like to have the result of this execution setup as a measure. While I could use the boolean logic of generic execution plugin to cobble this together, I can easily see how this could be extended. For example, if I were to run a sql statement, and I want all the results from the result set tracked as measures.
Firstly, I want to know if there is any plugin I could use for this that is already existing. The key requirements would be that it would need to result in measures that I could then track (even if its for a single value, that would get me over the hump of what I am trying to do).
Secondly, if a plugin doesn't currently exist to do something similar, is this type of generic execution on the road map? I don't want to do the work if there is a feature coming up that would trump this.
Thanks,
Chris
Can you access this link : https://apmcommunity.compuware.com/community/download/attachments/74383723/com.dynatrace.genericSqlMonitor_1.0.0.jar?version=1&modificationDate=1331577569527
It's not documented yet but it does pretty much what you're looking for.
Can't seem to access that link.
Is there anywhere else you could post that file where I might be able to get access?
I was able to download that, Thanks!
I will play around with it and see what it gets us. Much appreciated!
Do similar plugins exist for Oracle?
From the looks of the properties, this one works for Oracle, SQL server, DB2, and Postgre SQL.
Hey Christopher,
I'm not sure where you're at on the progress of the plug-in that can perform SQL queries but Bill (William) Zajac, a former Compuware Guardian, developed the attached plug-in that can perform SQL queries. You'll have to refer to him for any questions.
Please note that this is not an officially supported plug-in.
Hope this helps!
Hello,
Cannot get this to work and the LOG isn't really helpful since it only outputs the connection parameters in SEVERE log level. How to find out what is wrong?
2013-06-24 10:56:41 SEVERE [GenericSQLMonitor@MSSQL-invoicesvalidationstarted10mins_0] Here 2013-06-24 10:56:41 SEVERE [GenericSQLMonitor@MSSQL-invoicesvalidationstarted10mins_0] dbType=MSSQLServer 2013-06-24 10:56:41 SEVERE [GenericSQLMonitor@MSSQL-invoicesvalidationstarted10mins_0] Port=1433 2013-06-24 10:56:41 SEVERE [GenericSQLMonitor@MSSQL-invoicesvalidationstarted10mins_0] dbname=bscstracking 2013-06-24 10:56:41 SEVERE [GenericSQLMonitor@MSSQL-invoicesvalidationstarted10mins_0] host=10.xxx.xxx.xxx 2013-06-24 10:56:41 SEVERE [GenericSQLMonitor@MSSQL-invoicesvalidationstarted10mins_0] com.microsoft.jdbc.sqlserver.SQLServerDriver
Hi Jan,
I will email you a version of the plugin I built a few weeks ago that has more error handling. Never got around to fully test and clean it up but it should at least show you where the problem occurs...
Best, Roman
Hey guys, does anyone here have the newest version of this SQL Query Execution Plugin? I want to use part of the code to create a custom plugin for this customer.
I have attached the most current version I have to this post. If you make further changes or fixes please post it back here for whoever needs it...
Best, Roman
During the execution of some long queries in this client, the plugin could not fetch some data because of the connection timeout.
So what i did was setting the timeout to 300 seconds, just in case, in the createConnection() Method
DriverManager.setLoginTimeout(300);
But this could be added as a setting parameter when creating the monitor.
Welcome the
Dynatrace Community Forums
Check out the Forum User Guide and Forum Guidelines to learn how to get started.Community Member of the Month
September 2017
Announcing Dynatrace's Community Member of the Month for September 2017, Tarun A.! Click here to read more! 
