• 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 Ken L. · Oct 18, 2013 at 07:12 PM ·

Report Correlation

We have had some issues with long running SQL queries. We think that some bind variables may be effecting the performance. We have been capturing the bind variables and exporting to save sessions. We then perform a manual task of aligning purepaths with the matching bind values(from SQL statement) found by drilling down from purepath into database dashlet. Then enable the "show bind value" column. We take the pp information and the bind values and paste them into excel for analysis.

Is there anyway to correlate purepaths with the associated bindings with a dashboard/report/automation?. This is for 100's of purepaths.

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 Andreas G. · Oct 19, 2013 at 10:33 AM

Hi

I would use the opposite approache - meaning:

#1 open the database dashlet and turn on bind values

#2: focus on those SQL executions that take very long with those particular bind values

#3: drill to the PurePaths from that particular SQL Execution -> this will give you all PPs that made a call to this particular SQL with these bind values

#4: instead of copying these PPs into an Excel sheet I would EXPORT these PurePaths and give that to the engineers that need to look at it.

#5: Engineers import that exported session and see exactly those PurePaths with the call to that SQL Query.

Andi

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 Ken L. · Oct 29, 2013 at 04:52 PM 0
Share

Hi,

thank you for the response. The trouble with this approach is that the store procedure has low execution time, always. However we see the slow response of the store procedure on the databases side. I have open a new topic on slow queries execution time in database dashlet.

 

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

No one has followed this question yet.

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