• 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. · Jul 22, 2015 at 09:12 PM · business transaction

SQLs greater than x secs

Andi or anyone,

i would like to alert on all the SQLs if they are greater than x secs. So i have the below config of the BT and we have SQL aggregation is on.

When i drill down into one of the alerts, i  see one sql executed 4 times and total time is greater than 2 secs (which is the threshold i have put in the BT). But when i checked the individual sqls for that purepath none of them are greater than 2 secs. So i am wondering how can i achieve this?

 

 

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. · Jul 23, 2015 at 10:45 AM

Hi 

you need to specify "sum" as the aggregation option in your BT. Why? Because for a single PurePath your measure will provide a value for each individual SQL node in your PurePath. In your case that is 3. If you select "Last" then the value 5.96 will be used as result measure. Try "Sum" and you should get 5707.33 which will then trigger your threshold

Andi

Comment

People who like this

0 Show 8 · 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. · Jul 23, 2015 at 08:44 PM 0
Share

Thanks Andi for the reply.  Just want to make sure i have explained it clearly what i want to achieve. in the screenshot i provided i chopped off other queries as the only query that has high time is the first one which is executed 4 times and total is 5707.33. When i drill down, max time for any query was less than 2 secs. So it should not have alerted in the first place? I don't want to alert if the sum for a query is more than 2sec but i would like to alert when an individual query itself takes 2 secs. 

To give you another example - 

Here first query shows it has 6102 secs (for 4 executions) and may be that is why it is alerting as it is > 2 secs.  But when i checked the individual queries nothing is more than 2 secs. So how can i achieve that? 

 

 

 

avatar image Rick B. Venkata T. · Jul 24, 2015 at 12:59 AM 0
Share

Set the aggregation to 'max' if you want to achieve this

avatar image Venkata T. Rick B. · Jul 24, 2015 at 02:57 AM 0
Share

Thank you. i actually have max in the alert. i will try max in the BT itself

 

avatar image Venkata T. Venkata T. · Jul 24, 2015 at 06:20 PM 0
Share

Richard/Andi -  i tried with Max, but i still see sqls less than 2secs when i drill down into DB...

 

avatar image Rick B. Venkata T. · Jul 24, 2015 at 11:32 PM 0
Share

Do the results include SQL queries over 2s?  This is what I would expect, as the Business Transaction evaluates per-PurePath, so there may be other queries less than 2 seconds executing.  If you need PurePaths where all queries were over 2 seconds (which may never happen if there are multiple executions in the PP) then you would set the aggregation to 'min'.

Hope that helps,

Rick B

avatar image Venkata T. Rick B. · Jul 25, 2015 at 04:30 PM 0
Share

Rick,

i did not see a single sql with > 2 secs. 

avatar image Rick B. Venkata T. · Jul 28, 2015 at 02:52 PM 0
Share

I can reproduce what you are describing.  It seems to have to do with whether database statement aggregation is enabled.

If enabled, min/max/count are aggregated per statement

If disabled, aggregations are measured per execution

In my opinion this setting should not change the meaning of the metrics so I am opening a ticket.  I will update this post when I have a response from the lab.

Thanks,

Rick B

avatar image Venkata T. Rick B. · Jul 28, 2015 at 06:00 PM 0
Share

Thank you Rich. 

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

Splitting measure from two sources

Cannot add web request to BT

Configuration for JUnit Test Perfomance View (Business Transaction, Measure, Sensor pack methods)

Corrupted PurePaths and BTs

Does the new created Business Transactions could get the previous statistic data?

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