• 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 Pierre D. · Mar 04, 2015 at 07:39 PM ·

Finding who is executing a query

Hi,

 

I saw in dynatrace a delete query, but I would like to know which class is calling it .

in tree view I just see the JDBCStatement class for prepare statement and execute batch.

is there a mean to get it  ?

Pierre

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.

5 Replies

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

Answer by Andreas G. · Mar 09, 2015 at 05:15 AM

Hi Piere

Any more details on that hibernate bug? Would be cool if you could share your PurePath. I wont share any confidential information

As to your questions from March 4th. If you have listeners then dynatrace should be able to show you these listener executions. We support most of the common thread pools. if these listeners are executed in the main thread or in async threads we should show them as part of your inital PurePath that triggered these inserts, updates, ... if you dont see them I suggest you specify custom sensors for your listeners and configure them with "active and start purepath". Then you will definitely get PurePaths for these listener invokations

Andi

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 Pierre D. · Mar 08, 2015 at 01:15 AM

Hi Andy,

here some news.

In fact, it seems to be due to an hibernate bug. We've replace a set by a list in an delete deappears.

Furthermore we are handle fetch manually.

Causing some curious things in dyntrace.

Regards.

Pierre

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 Pierre D. · Mar 05, 2015 at 05:59 AM

hi andi,

I've defined a sensor on a specific method, and added jdbc sensor.

if while dynatrace is recording the purepath, there is a listener on an event occuring in the purepath, what happens with the listener ?

I suspect a listener which triggers the delete, and this delete is recorded in the purepath, but i don't have the listener trapped.

 

what do you think about this ?

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 Pierre D. · Mar 04, 2015 at 09:00 PM

Hi Andi,

in my case I don't see it.

I check if I'm allowed to send a purepath.

Pierre

 

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 Andreas G. · Mar 04, 2015 at 08:20 PM

The PurePath should show you where this statement gets called from. You may not see the direct calling method as you probably dont have a sensor for it. If the transaction runs slow you will see Auto Sensor Data which can give you more details on where the call comes from.

A best practice is to define some custom sensor rules for your data access layer API. That will give you more visiblity.

If you want - export one of these PurePaths and send it over as part of my http://bit.ly/sharepurepath program. Happy to give you some feedback on the PurePath

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.

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

1 Person is following this question.

avatar image

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