• Forums
    • Public Forums
      • Community Connect
      • Dynatrace SaaS & Managed
        • Dynatrace SaaS & Managed Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Free Trial
        • AppMon & UEM Open Q&A
        • AppMon & UEM Plugins
      • Data Center RUM
        • DC RUM Open Q&A
        • Enterprise Synthetic Monitoring
      • Dynatrace Synthetic Monitoring
        • Dynatrace Synthetic Open Q&A
        • Dynatrace Synthetic EAP Feedback
      • Keynote Synthetic Monitoring
        • Keynote Synthetic Open Q&A
        • Keynote Synthetic EAP Feedback
      • BSM Open Q&A
      • Dynatrace Open Q&A en Español
  • 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 5 attachments (including images) can be used with a maximum of 52.4 MB each and 262.1 MB total.

Welcome the
Dynatrace Community Forums

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

Community Member of the Month
September 2017

Announcing Dynatrace's Community Member of the Month for September 2017, Tarun A.! 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

Pre-defined sequence of purepaths as a BT 2 Answers

How to make business transactions NOT case sensitive 1 Answer

excluding Web request without referer 6 Answers

In the Servlet request comes an object ... 2 Answers

Forum Tags

upgrade nginx java diagnostics dotnet docker 6.5 ios appmonsaas database sensor performance warehouse chart hybris integration 6.3+ service metrics production web performance monitoring systemprofile transactionflow incidents test automation measures business transaction migration php community help javascript android dashlet server monitoring purelytics nodejs 6.2 system profile splunk uem appmon reporting framework appmon 7 license mobile monitoring regex collector installation adk licensing messagebroker web services apache xml support plugin iis dashboard rest webserver reports 7.0 mainframe client 6.1 configuration continuous delivery sensors security rest api agent web dashboard alerting window 6.3 administration
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace SaaS & Managed
      • Dynatrace SaaS & Managed Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Free Trial
      • AppMon & UEM Open Q&A
      • AppMon & UEM Plugins
    • Data Center RUM
      • DC RUM Open Q&A
      • Enterprise Synthetic Monitoring
    • Dynatrace Synthetic Monitoring
      • Dynatrace Synthetic Open Q&A
      • Dynatrace Synthetic EAP Feedback
    • Keynote Synthetic Monitoring
      • Keynote Synthetic Open Q&A
      • Keynote Synthetic EAP Feedback
    • BSM Open Q&A
    • Dynatrace Open Q&A en Español