07-11-2008 6:53 AM
hi
can anyone provide me tcode for performance tuning and usefull links and material for performance tuning
i need to know all aboutn performacne tuning and methods in detail for it
regards
Nishant
07-11-2008 8:08 AM
If you want to know all then you should start reading, tcodes will not help you.
I can offer you seven blogs:
SQL trace:
SE30
Measurements on internal tables: Reads and Loops:
How to Measure Operations on Internal Tables
Nonlinearity: The problem and background
Z_SE30_COMPARE
Nonlinearity Check
when you read them all, and understand them, then I would maybe
send you some more unpublished one
Siegfried
07-11-2008 7:59 AM
Hello
1. ST05 - Trace requests
2. SE30 - Runtime analysis
3. SE38 -> Environment -> Perfomance examples
07-11-2008 8:08 AM
If you want to know all then you should start reading, tcodes will not help you.
I can offer you seven blogs:
SQL trace:
SE30
Measurements on internal tables: Reads and Loops:
How to Measure Operations on Internal Tables
Nonlinearity: The problem and background
Z_SE30_COMPARE
Nonlinearity Check
when you read them all, and understand them, then I would maybe
send you some more unpublished one
Siegfried
07-11-2008 8:22 AM
>
>some more unpublished one
Would like to see those published!
07-22-2010 8:14 AM
hi
i'm just read them all
i almost understand them and i'm really wonder that you said - unpublished one
can you tell me that one?
07-11-2008 3:33 PM
Hi Nishant.
Transaction code for performance tuning:
SE30 - ABAP runtime analysis
ST02 - Tune Summary.
ST03 - Workload Analysis (Tuning of buffers,.
ST04 - Database Performance Analysis.
ST05 - Performance Analysis (SQL Trace, etc).
ST06 - Operating System monitor.
ST07 - Application Monitor.
ST14 - Application Analysis.
Performance Tuning:
[Published paper By Alfons Kemper, Donald Kossmann, Bernhard Zeller|http://www.dbis.ethz.ch/research/publications/19.pdf]
[SDN document reference|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/afbad390-0201-0010-daa4-9ef0168d41b6]
[Some performance tuning tips|http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp]
[A good and simple PDF to understand the concept of Performance tuning|http://www.esnips.com/doc/262fa696-10b5-44a0-8c4c-06a1cbaf247c/Wishnu---Performance-Tuning-an-Overview]
Good Luck & Regards.
Harsh
07-24-2008 11:56 AM
04-07-2009 1:13 AM
07-26-2010 11:33 AM
this is a two year old thread, I wonder who finds this still interesting. I wonder even more that some references are many years old.
Unpublished blogs, don't know whether I will publish them. All I have to say about ABAP performance is published in my
book (however only in German):
http://www.dpunkt.de/abap_performance
Siegfried
07-06-2013 5:37 AM
you need performance tuning because of large amout of data. if your program give output very late then be patient. analysis whole program when you want to do performance tuning, many tcodes are available SE30,ST02 TO ST07 AN ST14. but take simple method.
dont go with any tcode. which program need performance tunning execute it and open sm66.
and check if any query take loge time to fetch data from internal table then put secondary index in that select statement.
second thing check whole program and void use nesting loops in that program.
also use BINARY SEARCH in read statement.
07-07-2013 9:30 AM
Don't use BINARY SEARCH. Use a HASHED table or a SORTED table. Thread locked due to age.
05-11-2020 3:08 PM
I hope the above information is helpful like other answers on this page. These wiki pages are created in recent years, and they are under maintenance. It means that when there is some new information about this topic, the new information will also be merged into the above wiki pages.
For example, recently there is a new tool "profile data analyzer" which is a standalone tool to systematically analyze and visualize SE30/SAT trace and create analysis reports. The information for the profile data analyzer is also merged into the above wiki pages. (BTW, profile data analyzer also supports *.prf file from SAP JVM Profiler)
Best regards,
Qiansheng Wang