• 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
        • Enterprise Synthetic Monitoring
      • Synthetic Classic
        • Synthetic Classic Open Q&A
      • BSM Open Q&A
  • Home /
  • Public Forums /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
Question by Anirudha H. · Jul 13, 2015 at 07:51 AM · business transaction

How to add Top 10% worst performing SQL statements?

Hi,

I want to add Top 10% worst performing SQL statements on the dashboard.
I am using the database dashlet, it lists all the SQL statements, I couldn't find a way to filter the worst SQL statements.

Is there a way to filter?

Thanks

Comment

People who like this

0 Show 0
10 |2000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

2 Replies

· Add your reply
  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by Graeme W. · Jul 13, 2015 at 03:00 PM

Anirudha,

You can't do the "Top 10%" but you can do the top 10 (or 20 or 30) statements.

Right-click on the dashlet tab ("Database" in the screenshot below) and select "Edit Filter ..."

When the filter dialog opens, navigate to the "Top X" tab and set the values as shown:

Hope this helps!

-- Graeme

 

Comment

People who like this

0 Show 0 · Share
10 |2000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image

Answer by Anirudha H. · Jul 13, 2015 at 03:16 PM

Graeme,

Perfect, this is what I was looking for.
Appreciated

Thanks
Anirudha

Comment

People who like this

0 Show 0 · Share
10 |2000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Your answer

Hint: You can notify a user about this post by typing @username

Up to 10 attachments (including images) can be used with a maximum of 52.4 MB each and 262.1 MB total.

Welcome to the
Dynatrace Community Forums

Check out the Forum User Guide and Forum Guidelines to learn how to get started.

EMEA Community Member of the Month - November 2018

Announcing Dynatrace's EMEA Community Member of the Month for November 2018, Mathieu C.! Click here to read more!

LATAM Community Member of the Month - November 2018

Announcing Dynatrace's LATAM Community Member of the Month for November 2018, Rene S.! Click here to read more!

Follow this Question

Answers Answers and Comments

2 People are following this question.

avatar image avatar image

Related Questions

Welcome to the Business Transaction Management Forum 2 Answers

Copy BT from 4.2 to 4.1 1 Answer

PPs that call specific method argument 5 Answers

BT that splits into 2 groups: http and https 3 Answers

Business transaction on specific value of a JMS message 2 Answers

Forum Tags

nginx upgrade java diagnostics dotnet docker scheduler search 6.5 customization ios appmonsaas knowledge sharing browser agent mobileapp database sensor performance warehouse 7.1 chart hybris 6.3+ services production web performance monitoring user sessions transactionflow incidents test automation measures business transaction plugins migration php javascript android processes server dashlet monitoring purelytics nodejs 6.2 splunk system profile rest api uem appmon framework appmon 7 license mobile monitoring good to know collector installation adk purepath messagebroker web services apache guardian appmon 7.2 plugin iis splitting dashboard mq rest webserver reports 7.0 errors kibana mainframe client 6.1 configuration unique users forum user guide continuous delivery postgresql sensors security documentation agent web dashboard alerting load auto-detection window 6.3 dynatrace apm administration oneagent
  • 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
      • Enterprise Synthetic Monitoring
    • Synthetic Classic
      • Synthetic Classic Open Q&A
    • BSM Open Q&A