• 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 Roy L. · Mar 04, 2015 at 10:42 PM ·

How to chart Database Summary as shown in PurePath tree?

I have a problematic PP whose root cause is excessive DB queries for 3 separate tables, according to the PP tree for it.  For example, it has over 2500 executions for EACH table (2500 x SELECT * FROM ...).  The problem is, I would like to capture such individual statement counts as it appears in PP tree.

I have given up on the DB Count measure, no matter what I try it doesn't seem to give me proper results.  In that same time frame the count was 34, when it should be in the thousands, as noted above.  For reference, I added DB Count to the BT as a result, using 'sum' aggregate.  Then in the chart, I add it using 'sum' aggregate again.

Any advice on how to capture the DB summary correctly?

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.

1 Reply

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

Answer by Roy L. · Mar 04, 2015 at 10:43 PM

Sorry, I should add I am trying NOT to go the instrument route, as that could lead to bad performance, given the number of statement executions that happen!

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 Reinhard W. · Mar 04, 2015 at 11:12 PM 0
Share

Roy,

no need to instrument anything for Database Statements, the JDBC sensor will exctly capture this information for you already.

You are probably mixing the (avg) DB count that you will see per default on a BT that you have added the DB Count as a result measure on.
Likely you have done the following:

  • added DB Count (sum) to the BT's result measure
  • showing the BT dashlet you will see the average DB count of all PPs which is probably 34

What you will need is an additional filter on the BT to filter out those transactions that have more than X DB statements.

In the costco PreProd Profile check the 'DB Statement Requests' BT this is exactly doing what you are looking for, for PPs with more than 100 statements.

Reinhard 

  

avatar image Roy L. Reinhard W. · Mar 05, 2015 at 10:43 AM 0
Share

Thanks Reinhard,

Yes I used 'DB Statement Requests' BT as the prototype which to copy from.  But one key difference: you're right I don't have a DB filter.  Reason is, I still want to capture non-DB requests in this BT (due to caching layer not all requests will hit the DB).  Does this skew the results of the DB Count measure?  I think then I must duplicate this BT and basically add the additional filter for DB Count, or is there a more elegant solution to capture PP's with or without DB activity in a single BT?

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