• 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 Venkata T. · Apr 25, 2013 at 12:49 PM · business transaction

Sqls per purepath

Hi,

I am trying to get sqls executed per purepath. So i have created page action type business transaction and have db count in the calculate results. But i am not getting results. I have attached screenshot. can you please let me know if this is the right way to do this or if there is any other way. if this is right way what am i missing as it is not showing data.

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. · Apr 25, 2013 at 01:06 PM

If you have UEM (User Experience Management) - then this BT should work (by looking at the screenshot).
In your posting you say that you want to know DB Executions per PurePath - that makes we wonder if you really have UEM or if you really want to focus on just Server-Side PurePaths.
If you do not have UEM I suggest that you create a Server-Side PP BT, use the same Result measure and use e.g: the Web Request URI Pattern Measure for splitting

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 Venkata T. · Apr 25, 2013 at 01:12 PM 0
Share

Hi Andi,

I tried server side BT. but by doing that i get the average across similar number of web uris right. So for example, i might have 100 /search uris and some might have 3k sqls and some may have 500 sqls so what i see see is the average number of sqls but not the sqls for each uri.

Good point Andi, i just realized we have UEM but we stopped it as it brought down our jvm after we have added piece of js code to track the dojo ajax calls. So we stopped it for now. i have to open a ticket for this.

avatar image Andreas G. ♦ Venkata T. · Apr 25, 2013 at 02:54 PM 0
Share

If the URI is not unique enough for your scenario you may want to split by something else, eg: a specific HTTP parameter or the method name of a specific class that you know gets invoked.

If you do not have UEM in the moment then you have to go with Server-Side PPs. The only trick now really is to find something on the PurePath that allows you to split in a way that gives you the transaction splitting you need

avatar image Venkata T. Andreas G. ♦ · Apr 25, 2013 at 03:05 PM 0
Share

Got it. Thank you Andi.

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

2 People are following this question.

avatar image avatar image

Related Questions

API splitting for only webrequest within purepath

Application utilization

Measuring Sub-Path invocations and response times

Alert for Execution time per transaction parameter

Corridor for Business Transaction in web dashboards

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