Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how will we trace which select query is taking too long time in abap

former_member697528
Discoverer
0 Kudos
1,938

while running any program in abap how can you know which statements is taking more time to execute and how can we overcome that?

7 REPLIES 7

sveabecker
Product and Topic Expert
Product and Topic Expert
0 Kudos
1,147

Welcome and Thank you for visiting SAP Community to get answers to your questions. Please add more details to your question, e.g. you can also add a screenshot. With that, you can reach a broader range of experts to get your question answered. I also recommend to do this tutorial https://developers.sap.com/tutorials/community-qa.html

The more details you provide, the more likely it is that members will be able to assist you.

Regards, Svea

SAP Community moderator


----- Stay up-to-date with SAP Community and subscribe to What's New today! -----

geert-janklaps
Active Contributor
1,147

Hi,

A good starting point will be running SAT checks (ABAP Runtime Analysis) using transaction SAT.

More info on SAT can be found here: https://www.saptechnicalguru.com/sat/

You can also run ST05 (SQL tracing) to do some further analysis, more info can be found here:

https://blogs.sap.com/2007/09/05/the-sql-trace-st05-quick-and-easy/

Best regards,

Geert-Jan Klaps

Sandra_Rossi
Active Contributor
0 Kudos
1,147

Look at database shared cursor (ST04N), and things like that...

0 Kudos
1,147

Hi Sreya,

By running ST05 (SQL Tracing) we can check which select query is taking more time.

we can overcome by using performance standards tips for abap programming. refer this link for more information

https://help.sap.com/viewer/2e90b26cf7484203a523bf0f4b1bc137/7.5.9/en-US/b3573138bb684b128e5067a44af....

Hope this may help you.

Best regards,

Nagarathna

former_member697510
Participant
0 Kudos
1,147

Hi Sreya,

Refer this link

https://www.youtube.com/watch?v=xx_sm4alocc&t=310s

I hope this will help you.

Thanks,

Anupam.

former_member697611
Discoverer
0 Kudos
1,147

In performance tuning by using running ST05 SQL Tracing we can check which select query is taking more time ABAP .

refer this link.

https://youtu.be/_w3rRbtlPfQ

Thanks,

Jaibun J.