Skip to Content
author's profile photo Former Member
Former Member

Performance Analysis of Function mOdule


i had to make a document on performance analysis of certain function modules assigned to me.

so can you tell me what should the steps to do performance analysis? what all the things (along with the transaction) to be looked for?

i checked SE30, ST05, STAD etc transaction. But i dont know how to read STAD-STAT analysis, and how to evaluate the performance using them?

Can anyone guide me on this, and if anyone have any document regarding this, can you share it with me??



Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Jun 12, 2008 at 12:10 PM

    the STAD data can not really be taken to evalute performance. The statistics just show you, the response time, CPU time, DB time

    (mainly) and a lot of other numbers, but no details.

    Can you see these number for your applacition? Restrict to your name, and sometimes it is better to increase the time interval a bit,

    set the starting point 10min back and increase the interval to 30min, then you can see everything.

    You see ome line per process. This is good overview, and numbers without trace overhead.

    You need the traces, SE30 and ST05, to see the details, only there you can decide what takes to long, is executed too often, etc etc.

    SQL trace:




    If you follow this guidline you should be able to find most of your problems, ask again if you don't know how to slove them.


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Siegfried,

      I am looking at the ST05 transaction, and got a feel about what this trace bring as related with the performance analysis. I followed all the guidelines you mentioned. I am seeing at all the statistical values coming after clicking on Explain tab, but still, its not totally cleared as how to analyze all those statistical values, and how can one come to conclusion on performance. What all the things to keep in mind and basically how to read all those values?

      although, the document provided by you gave me an insight into the procedure related ST05, some things i understand, but still there remains some puzzled parts for me (as reading the trace and coming to a conclusion)..

  • Posted on Jun 13, 2008 at 09:31 AM


    please read the section 4. the SQL blog carefully. These are the checks you should do.

    Do them for the TOP contributions, highist duration.

    Slow processing, => problem with index, check explain

    Many records, => something wrong?

    Many executions => why

    Buffer column => bypassing buffer

    Identical, please avoid

    If there is nothing left, then you are fine = optimal SQL behavior.

    Please give feedback, what you still don't understand.


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 14, 2008 at 10:04 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2008 at 01:09 AM


    By using se30 can know where the bad performance.So that we have to check that type of scenarios.So using this we can know overall performance of report that means weather itz upto mark or not.

    By using st05 can know exatly where the bad performance statement.So that directly we can check that specific sql statement.To run st05 we need to run our program(report) and st05 transaction parallely.

    Apart from these two tansactons, we have code inspector also.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.