se30 - runtime analysis basic question

[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]

abap -

---

> usage of data declarations , like internal tables, simple variables,

the more u use the longer the line in SE30

database -

---

> usage of database table... to make sure the minimum usage of database , u have to avoid selects in loop , nested selects , ...

system ---> I guess this is CpU usage

Message was edited by:

Chandrasekhar Jagarlamudi

[Former Member]

Hi Maahi Verma,

In SM30(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 ,

ABAP : % of time taken by your abap code

Database : % time taken during data base access and other operations

System : % of time taken by SAP system

Red indicated that performance can be improved and it current status is not satisfactory adn green means that performance seems to be ok.

The optimal case is when you have all the three parameters in green m but it is generally not possible easily beacuse some programs have a lot of database operations while some have small but a lot of abap processing.

Regards

Arun

[Former Member]

Hi arun,

in the same post nagraj has replied that if abap usage is more it is better.

that means it will be red in colour and percentage usage will definitely be more 50 %.

and you say Red indicated that performance can be improved.

one of my test program has 92% abap usage..do you think there is any scope for improvement?

regards,

maahi