• 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 Charaka W. · Jul 02, 2015 at 11:09 AM ·

Database Dashlet Exec Avg time and DB Time Measure

Hi, 

First of all I m quite new to Dynatrace so bare with me, 

We have a Java application with a MS SQL server that Dynatrace monitor (Only the Java Application) and recently have observed one of the dashboards we have which got a chart of a Average DB Time, it is indicating that it has doubled, so I started looking in to finding what happened and was going through and comparing 2 time slots before and after the increase in DB Time on the database dashlet to see if I can see any inconsistencies. 

When I compare Database Time Measure (In the Measurements) and the Exec Avg in Database Dashlet under Transaction response time contribution look inconsistent,

For example 

The DB Time(Avg) is showing it has jumped from 1.68 to 3.29 but in the Database Dashlet under Transaction response time Contribution  Exec Avg has not changed in that proportion.  

Tried finding some documentation but non that explains it well,

 So What I m after is what does the Exec Avg, Exec Total, Executions  under transaction response times in Database Dashlet mean? and How does that co relates to DB Time and DB Count Measures,

Please help.

Thanks in advance.

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.

2 Replies

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

Answer by Graeme W. · Jul 07, 2015 at 07:50 PM

Charaka,

This certainly seems odd.  Can you post two small session files (even a single PP) from before and after the configuration change?

If for some reason this isn't possible, I might recommend that you open a support case and upload the session files there (along with a support archive).

What release / version are you running?

-- Graeme

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. · Jul 02, 2015 at 07:26 PM

Hi

Any chance you can export some PurePaths from both time periods? Or show some screenshots?

I always like the comparison feature of the Database Dashlet itself. You can specify two timeranges and it will show you the difference in both Exec Time but also in Exec Count. Also the total sum would be interesting to compare instead of just the individual differences between single SQL statements. Maybe you get a changed access pattern - meaning - you have one SQL statement that is not necessarily slower than before but is not called much more frequently. If this statement has a higher average than others that might be called less now it would explain an overall increase in average execution time

So - have a look and compare two timeslots but also look at Execution Count and at Execution Sum

Comment

People who like this

0 Show 2 · 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 Charaka W. · Jul 07, 2015 at 09:59 AM 0
Share

Hi Andreas,

Thanks for the reply, Managed to find the problem, around the same time we see the DB Time going up, we have changed the capture settings for JDBC sensor configuration as part of a recommendation to be "No Aggregate or bind value capturing" to "Enable Aggregation", when I rollback the change the DB time went back to what it used to be,

Now the question takes a different prospect, Have we been monitoring the correct DB Time before or are we looking at the correct one now?(Enabled aggregation) , What is the correct metric? And also Aggregating the capture setting effecting the way it calculates the DB Time kind of worries me, Any thought on this? really appreciate you response.    

avatar image Andreas G. ♦ Charaka W. · Jul 08, 2015 at 05:52 PM 0
Share

The timings SHOULD NOT change. If you see different timings this might indicate a bug in dynatrace.

What version of dynatrace is this?

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