• 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 Rick B. · Jun 17, 2013 at 02:53 PM ·

5.5 Database Node Aggregation

Hi All,

Trying to determine the possible impact of migrating to 5.5 from 4.2 at one of my customers. Just want to verify what I believe to be true:

In our case for every JDBC query there is a prepareStatement(), getConnection(), and executeQuery() invoked. Will these become one node instead of 3 after the agent upgrade?

Thanks,
Rick B

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

Answer by Guenter H. · Jun 26, 2013 at 01:23 PM

Hi all,
tweaked Sensor Properties#DB, and Database Query Statement Aggregation in JDBC Sensor and ADO.Net Sensorto be more informative and accurate.

Looking forward to the things to come
G.

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 Christian S. · Jun 17, 2013 at 03:18 PM

hi Rick,

just adding to Rob's comment:

the DB node aggregation in 5.5 will aggregate preparations & executions so they will be grouped by SQL string (not including bind values).
getConnection() calls will not be aggregated yet, this is something we're currently working on.

best,
Christian

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 Rick B. · Jun 17, 2013 at 03:20 PM 0
Share

Awesome Christian, that's what I was hoping. Great to know there is continued work on it as well but this should have a big impact in the meantime.

avatar image

Answer by Rob V. · Jun 17, 2013 at 03:11 PM

The dtMigration tool should work fine for you on this.

The new database aggregation is an option available to you in dT 5.5. You don't have to use it, but I know you've been looking forward to it! :-)

The aggregation is different from what  you mention above. It collapses "like" statements, not "statement families" as you're asking.

See this for some details: https://apmcommunity.compuware.com/community/display/DOCDT55/JDBC+Sensor#JDBCSensor-DatabaseQueryStatementAggregation

Rob

Comment

People who like this

0 Show 3 · 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 Rick B. · Jun 17, 2013 at 03:16 PM 0
Share

I had seen that but still don't quite know what to make of it or how to interpret your explanation. I guess I'll see for myself, but can anyone say in general if this optimizes MPS (NPS)?

avatar image Christian S. Rick B. · Jun 17, 2013 at 03:19 PM 0
Share

and of course this reduces NPS, as the aggregation happens on the agent.

avatar image Rob V. Rick B. · Jun 17, 2013 at 03:20 PM 0
Share

Yes, the goal is absolutely to reduce MPS.

What I meant was that it would take copies of the same statement and collapse them into one line. (In the screenshot, it has the queries and a count associated with them). What's it's not going to do is take create/prepare/execute and turn that into single nodes. I think (but do not know for sure) that this kind of optimization is in the works. Perhaps the lab can comment on that.

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

4 People are following this question.

avatar image avatar image avatar image 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