Slow Queries Analysis

Posted by voodoo on 11-Jul-2018 11:00

Hello Experts,

I'm wondering whether a way exists to analyse slow queries (like a top 10 of slowest queries).

If you've have some solutions for my problematic, I will be glad to hear them.

Thank you in advance,

Voodoo

OpenEdge RDBMS - Forum

All Replies

Posted by Mohd Sayeed Akthar on 06-Jun-2019 11:19

Hi Voodoo,

OpenEdge SQL does not have any such feature to get the information on slow running queries. However, this would be a nice enhancement to have.

You can add this as an idea (an enhancement) for the product over here.

community.progress.com/.../openedge_database_enhancements_-_tell_us_what_youd_like_to_see

This list gets evaluated by Product Management at Progress.

Thanks,

Akthar.

Posted by ducity on 06-Jun-2019 22:48

Might you not be able to switch on logging/trace in the ODBC/DNS configuration?

Posted by ChUIMonster on 17-Jun-2019 18:36

Why should such a feature be confined to SQL?  Surely all slow queries are worth improving.  4gl or SQL.

This thread is closed