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
Answer by Valerio F. ·
Hi all,
Is there an official page of the GenericSQLPlugin?
At the moment I'm configuring it on customer site, to run a custom query. Thing is, the query is too long for the plugin, that automatically truncates it. Do you guys know how to extend the default "Query Size" value, so it could accept longer queries?
Thanks, Valerio
Hi Valerio
your best bet, is to checkout the module (via the client in the plugin menu) and modify the code yourself to achieve what you need. Repackage it and re-deploy it as a new version.
Regards
Flo
Answer by Renato P. ·
Nice Jim, I will take a look.
Just one thing I noticed about the behavior of the plugin. Sometimes, looks like the plugin looses the conection with the DB, So when that happens it does not renew the db connection then I have to manually stop and start the plugin or sometimes restart the collector to make it to work again.
Answer by James M. ·
Checkout the latest version of the DB Query Monitor plug-in. It supports query timeout periods, and also has measures that you can hook up to incidents for total response time, query response time, and connect response time. Regards, Jim
Answer by Renato P. ·
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.
Answer by Lopes D. ·
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.
Answer by Romppanen, J. ·
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
Answer by Joshua R. ·
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!
JANUARY 15, 3:00 PM GMT / 10:00 AM ET