Too much Execution time for Custom Programs (Z development)

[Muhammad_Raza]

Hello everyone,

I have successfully rebooted my production server, but we are experiencing issues with the execution response time of custom reports. After this activity, all custom programs developed with ABAP (programs starting with the Z character) are very slow with execution times taking hours, whereas previously these reports showed output in 5 to 10 minutes.
At times, they even show timeout errors due to the intense execution time that increased after the reboot. I have checked all system configurations, but to no avail.
It is worth noting that all custom programs are running perfectly on QAS and Sandbox and are showing results within minutes.
ABAP developer has stated that the code has no issues regarding time consumption of programs and the programs are running within minutes on other servers.

[Sandra_Rossi]

Ask an experienced ABAP developer to analyze one slow program in production.

[FredericGirod]

Run one program using transaction SAT, it will help you to identify what is time consuming in the program

[S_Sriram]

Hi Rehmen

Using the transaction code ST12 enables the trace to check the overall performance trace and Sql trace summery.

refer to the link on how to enable trace

https://blogs.sap.com/2013/07/17/st12-trace-step-by-step-instruction-on-how-to-use-it-for-analysis/

Regards

SS

[Muhammad_Raza]

Dear S.Sriram,

Thank you for your response. i have trace and get DB is red in Abap Trace. i am showing you S.C. Please tell me how can i solve it?

SQL summary..

[Sandra_Rossi]

raza0320 It's clear that the custom program is not efficient at all. Ask the ABAP developer to fix it. Only your developer knows the custom program, the execution context and so on, so we can't help on that without any further details.

[Muhammad_Raza]

@Sandra Rossi which kind of information you want more?

[S_Sriram]

Hi Rehmen

In the SQL Summary check the top 12 durations it is slightly high because the DB level is high,

You can check if any table indexes are missing in the below screenshot

capture.jpg

Regards

SS

[S_Sriram]

Hi Rehmen

As rightly said by Sandra, you have to check with ABAPer, to fine-tune the Custom Z program, from the SQL summary you can see the top 12 tables are taken a huge amount of time to execute

Regards

SS