Application Development and Automation 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: 
Read only

tcode for performance tuning and usefull links and material for pt

Former Member
15,274

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
Read only

Former Member
6,022

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

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

11 REPLIES 11
Read only

Former Member
0 Likes
6,022

Hello

1. ST05 - Trace requests

2. SE30 - Runtime analysis

3. SE38 -> Environment -> Perfomance examples

Read only

Former Member
6,023

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

Read only

0 Likes
6,022

>

>some more unpublished one

Would like to see those published!

Read only

0 Likes
6,022

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?

Read only

Former Member
0 Likes
6,022

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

Read only

Former Member
0 Likes
6,022

This message was moderated.

Read only

Former Member
0 Likes
6,022

closed

Read only

Former Member
0 Likes
6,022

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

Read only

jaydalwadi
Participant
0 Likes
6,022

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.

Read only

matt
Active Contributor
0 Likes
6,022

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

Read only

qiansheng_wang
Product and Topic Expert
Product and Topic Expert
0 Likes
6,022
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