abap performance trace

[Former Member]

Hi,

can anyone provide me the workbench tools for performance trace and runtime analysis.

step by step procedures will be much appreciated.

thanks and regards,

maahi

[Former Member]

hi,

check this --

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5d0db4c9-0e01-0010-b68f-9b1...

regards,

pankaj singh

[Former Member]

Hi Maahi ,

Run Time Analysis

Transaction : SE30

In the transaction type in the program name and press execute , it will output the run time analysis of the program.

performance trace

Transaction ; ST05

In this transaction go and press the button Trace On

Then execute your program

Go back to ST05 and press Trace Off

Then Press LIST Trace.

Hope this helps.

Regards

Arun

[Former Member]

Hi arun and laxman,

thanks for the replies .. can you tell me..what are the necessary things i have to take care to improve the performance.

my program consistes of FMs RFCs and BDC.

thanks,

maahi

[Former Member]

Hi Maahi ,

Few stuff which you need to take care to imporve the performance of program is as below.

1. Try to give all the key feilds in where clause of the select statement , if you dont have all check if there is an index for the table and can you use any of the index.

2. Retreive only required feilds from table.

3. Dont use Select ... EndSelect , instead of that use select into table.

4. Dont use table with header lines , use explicit work area.

5. Read internal table with Binary Search .

Reagrds

Arun

[Former Member]

hi,

what is abap,database and system in se30.

what does red and green colour indicate.

how much percentage of execution time is considered as optimium ?

regards,

maahi

[Former Member]

Hi Maahi Verma,

In <b>SM30</b>(Runtime Analysis), Abap, database and System are the three rows which indicate the performance of our program.

These indicate the load on them by the program, which is determined by the length of the bar beside them.

For better performance, abap should should be around 90% +, database should be 10% - and system can be around 20% - 45%.

This means that if the load on the database is less , performance is more. For abap the % should be more indicating the fine tuning of the coding so that DB laod can be reduced to improve the performance.

Hope this resolves your query.

Reward all the helpful answers.

Regards

[Former Member]

Hi Maahi,

These are all steps for performance steps take care:

ST05

SE30

SLIN

avoid nested loops and avoid select in the loop.

Check with basis guys estimation cost for program.

Hope this helps you, reply for queries, Shall post you the updates.

Regards.

Kumar.

[Former Member]

Hi Maahi Verma,

Check this info.

<b>ST05</b>

You use ST05, Trace Request, to do a SQL trace.

When using SQL trace, it is good to run the program in debugger and just before you execute the SQL, go to ST05 in another session and turn the trace on.

After, or when, the SQL is finished, you can turn the trace off.

Then click on List Trace to see the details.

This is the way to control the traces.

If you just turn the trace on and then execute the program, you will get everything and will be overflooded with unnecessary information.

<b>Runtime Analysis</b> checks program execution time in microseconds. When you go to se30.if you give desired program name in performance file. It will take you to below screen. You can get how much past is your program.

Hope this resolves your query.

Reward all the helpful answers.

Regards