• 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
  • 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 |2000000 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

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

2 Replies

  • Sort: 
  • Most voted
  • Newest
  • Oldest
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 |2000000 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

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

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 |2000000 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

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 Community User Guide and First steps in the forum to learn how to get started.

Community Member of the Month
July 2019

Announcing Dynatrace's Community Member of the Month for July 2019, Wai C.! Click here to read more!

Employee Member of the Month
July 2019

Announcing Dynatrace's Employee Member of the Month for July 2019, Patrick H.! Click here to read more!

Live webinar: Automate Deployment and Site Reliability with Bots, ChatOps, and Dynatrace

oin us in a session where Zohaib UL-Hassan and Nestor Zapata from Citrix will explain their different bot use cases, get insights into how they implemented them, and learn how you can integrate Dynatrace monitoring data into your own bot automation framework.
Tuesday, July 23, 4:00 p.m. CEST/10:00 a.m. EDT
Register here

Live webinar: Automate Deployment and Site Reliability with Bots, ChatOps, and Dynatrace

oin us in a session where Zohaib UL-Hassan and Nestor Zapata from Citrix will explain their different bot use cases, get insights into how they implemented them, and learn how you can integrate Dynatrace monitoring data into your own bot automation framework.
Tuesday, July 23, 4:00 p.m. CEST/10:00 a.m. EDT
Register here

NAM 2019 SP1 is available

See what's been improved in metric charts, Report explorer, and Reporting data servers screen.
Learn more

Live webinar: Automate Deployment and Site Reliability with Bots, ChatOps, and Dynatrace

oin us in a session where Zohaib UL-Hassan and Nestor Zapata from Citrix will explain their different bot use cases, get insights into how they implemented them, and learn how you can integrate Dynatrace monitoring data into your own bot automation framework.
Tuesday, July 23, 4:00 p.m. CEST/10:00 a.m. EDT
Register here

Follow this Question

Answers Answers and Comments

2 People are following this question.

avatar image avatar image

Related Questions

Can you use a proxy server in business transaction feed? 2 Answers

How can I get multi step Keynote Measurements into a Business Transacation in UEM 1 Answer

Same Named Database Instance, Multiple Schemas 2 Answers

How to filter a specific application for user action in a BT? 5 Answers

filter for %failed in BT 1 Answer

Forum Tags

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