• 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 Jaydatt D. · Aug 27, 2015 at 07:16 AM · database

Unable to trace query taking high response time in database report.

Hi All,

We are getting a query which taking almost 10 min time for execution in dt database dashboard as shown below.

Whereas when we checked for this query in database we haven't found this query taking that much of time.

But what we have observed is number of execution in dt is much lesser than AWR report.

is it so that dt is combining the number of executions together and showing that it is running for long time?

Please help.

Regards,

Jaydatt

query.png (44.8 KiB)
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.

3 Replies

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

Answer by Andreas G. · Aug 28, 2015 at 08:04 AM

Well. The other thing is that Dynatrace only sees those SQL Executions that are executed in the context of a PurePath. By Default you will get PurePaths for your web requests. I dont know your application - but - could it be possible that your application is also doing some background work in worker threads that are not yet captured by Dynatrace as PurePaths? If that is the case you can configure custom entry point sensors so that dynatrace also captures these types of transactions that are not triggered by an end user.

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
Best Answer

Answer by Andreas G. · Aug 27, 2015 at 09:58 AM

Based on the Screenshot this SELECT statement is executed 432 times with an average execution time of 2.5s which is totalling up to 10mins. You also have a wide spread execution time range. Min is 0.51 - Max is 544s.

Everytime you open a dashlet like this you will see an aggregated view of all calls to each SQL statement in the specified timeframe -> the default timeframe is 30 minutes. So - when you compare data sets from dynatrace and AWR make sure you look at the same timeframe

Also remember that dynatrace sees execution time as seen from the application as we instrument JDBC/ADO.NET. If there is a network issue between your App Server and the Database dynatrace would include that network time in the database as well

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 Jaydatt D. · Aug 27, 2015 at 10:41 AM

Hi Andi,

surprising the time-frame for both that is dt as well as AWR report is 1 hr so time frame is same.

still the execution count differs drastically between AWR report and dt report.

Best Regards,

Jaydatt

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

6 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

How to migrate the performance warehouse to another server

Map Database agent in a particular system profile

upgrade and migration of appmon 6.2 to 7

JDBC Bind Value Maximum Length

JDBC Connection Pool Size vs. Connection Pool Percent Used

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