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: 

tcode for performance tuning and usefull links and material for pt

Former Member

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

1 ACCEPTED SOLUTION

former_member194613
Active Contributor

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

11 REPLIES 11

Former Member
0 Kudos

Hello

1. ST05 - Trace requests

2. SE30 - Runtime analysis

3. SE38 -> Environment -> Perfomance examples

former_member194613
Active Contributor

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

0 Kudos

>

>some more unpublished one

Would like to see those published!

0 Kudos

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?

Former Member
0 Kudos

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

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

closed

former_member194613
Active Contributor
0 Kudos

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

jay_dalwadi
Participant
0 Kudos

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.

matt
Active Contributor
0 Kudos

Don't use BINARY SEARCH. Use a HASHED table or a SORTED table. Thread locked due to age.

qiansheng_wang
Advisor
Advisor
0 Kudos
Hi, here are some wiki pages that summarized the ABAP performance tools centrally, including resources for further reading, e.g. Note/KBA, SAP online help links, or other wiki pages for the individual tool.

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