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.
Showing results for 
Search instead for 
Did you mean: 

Performance Analysis of Function mOdule

Former Member
0 Kudos


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??




Active Contributor
0 Kudos

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.


0 Kudos

Thanx Siegfried for giving me such valuable information. surely i will try those transaction and follow the guidelines, and will get back to you on those.


0 Kudos

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)..

Active Contributor
0 Kudos


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.


Former Member
0 Kudos


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.