• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home /
  • Public Forums /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
Question by Christopher P. · Mar 12, 2013 at 02:53 PM · plugins

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

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

15 Replies

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by Valerio F. · Sep 22, 2015 at 09:17 AM

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

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Florent D. · Sep 22, 2015 at 10:49 AM 0
Share

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

avatar image

Answer by James M. · Sep 29, 2013 at 07:19 PM

 

can you turn the plug-in on to log level 'fine', and send me the logs around this, and any SQL State error codes?

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by James M. · Sep 29, 2013 at 06:52 PM

 

which database/version are you seeing this with?

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Renato P. · Sep 29, 2013 at 06:42 PM

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.

 

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by James M. · Sep 23, 2013 at 07:58 PM

 

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

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Renato P. · Sep 03, 2013 at 09:17 PM

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.

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Lopes D. · Aug 28, 2013 at 10:30 PM

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.

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Roman S. · Aug 29, 2013 at 09:55 AM 0
Share

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

avatar image

Answer by Romppanen, J. · Jun 24, 2013 at 10:24 AM

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
Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Roman S. · Jun 24, 2013 at 10:41 AM 0
Share

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

avatar image

Answer by Joshua R. · May 22, 2013 at 05:07 PM

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!

dynaTrace_4.2.0_SQL_Query_Plugin.jar

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Rick B. · Mar 14, 2013 at 05:49 PM

Do similar plugins exist for Oracle?

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Christopher P. · Mar 14, 2013 at 05:56 PM 0
Share

From the looks of the properties, this one works for Oracle, SQL server, DB2, and Postgre SQL.

  • 1
  • 2
  • ›

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

5 People are following this question.

avatar image avatar image avatar image avatar image avatar image

Related Questions

Action Plug-in SourceType of AgentGroup

meaning of SNMP message

Can I use the plugin-Log file scraper to monitor the Weblogic on AIX ?

Oracle Plugin Issue

Monitor Unable to execute on Host

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A