2020 Aug 19 11:53 AM
while running any program in abap how can you know which statements is taking more time to execute and how can we overcome that?
2020 Aug 19 11:53 AM
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
2020 Aug 19 12:08 PM
I used to use SE30, but you can also use SAT - please see this blog https://blogs.sap.com/2018/12/02/sat-runtime-analysis-from-ui/ and https://blogs.sap.com/2018/01/22/secrets-of-the-abap-debugger-advanced-abap-debugging-techniques/
2020 Aug 19 12:10 PM
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
2020 Aug 19 12:12 PM
Look at database shared cursor (ST04N), and things like that...
2020 Aug 19 12:41 PM
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
Hope this may help you.
Best regards,
Nagarathna
2020 Aug 20 6:08 AM
Hi Sreya,
Refer this link
https://www.youtube.com/watch?v=xx_sm4alocc&t=310s
I hope this will help you.
Thanks,
Anupam.
2020 Aug 21 10:41 AM
In performance tuning by using running ST05 SQL Tracing we can check which select query is taking more time ABAP .
refer this link.
Thanks,
Jaibun J.