ST03n - Query ?
Is there any maximum total response time and average response time values set for all the transactions ? In my system, i have checked ST03N, the total response time for some transactions exceeds more than 5 to 501,137 and Average response time exceeds 2000. Is this common ? Please advise further.
Archana Amlapure replied
In addition to above points ,if you see performance issue with particular transaction or program, you can take a trace in St12 for tat tr or program and found time is spent in ABAP(CPU time) or in DB. So if ABAP time is high ,you have to tune some particular code or function mode(program or fuction moddule which has high net time in ST12 trace) or if it is DB time ,then you may find some expensive SQL statement ,which has to be tuned to reduce DB load.
If it is SAP standard program or tcode ,you may search SAP Notes.You can find some code correction or solution for those programs. IF it is Z-programs then you have to consult with your ABAP developer to tune those programs.
I hope this helps.