Skip to Content
avatar image
Former Member

tcode for performance tuning and usefull links and material for pt

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    Jul 11, 2008 at 07: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:

    The SQL Trace (ST05) – Quick and Easy

    SE30

    The ABAP Runtime Trace (SE30) - Quick and Easy

    Measurements on internal tables: Reads and Loops:

    Runtimes of Reads and Loops on Internal Tables

    How to Measure Operations on Internal Tables

    How to Measure Operations on Internal Tables

    Nonlinearity: The problem and background

    Performance Problems Caused by Nonlinear Coding

    Z_SE30_COMPARE

    A Tool to Compare Runtime Measurements: Z_SE30_COMPARE

    Nonlinearity Check

    Nonlinearity Check Using the Z_SE30_COMPARE

    when you read them all, and understand them, then I would maybe

    send you some more unpublished one 😊

    Siegfried

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 11, 2008 at 02: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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 11, 2008 at 06:59 AM

    Hello

    1. ST05 - Trace requests

    2. SE30 - Runtime analysis

    3. SE38 -> Environment -> Perfomance examples

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 24, 2008 at 10:56 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 07, 2009 at 12:13 AM

    closed

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 26, 2010 at 10: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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 06, 2013 at 04: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.

    Add comment
    10|10000 characters needed characters exceeded