How to add Top 10% worst performing SQL statements?

Question

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

0

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 1 · 2015-07-13T15:16:42Z

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

Graeme,

Perfect, this is what I was looking for.
Appreciated

Thanks
Anirudha

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 2 · 2015-07-13T15:00:30Z

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

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

How to add Top 10% worst performing SQL statements?

2 Replies

How to get started:

NAM 2019 SP3 is available

LIVE WEBINAR

Follow this Question

Related Questions

Forum Tags