topic performance tuning help in Application Development and Automation Discussions

performance tuning help

Former Member — Tue, 19 Jun 2007 03:44:36 GMT

hello friends,

i am supposed to use ST05 and SE30 to do performance tuning,and also perform cost estimation,

can some plz help me understand, i am not that good at reading large paragraphs, so plz donot give me links to help.sap

thank you.

Former Member — Tue, 19 Jun 2007 03:48:27 GMT

Se30 is the runtime analysis

Here it will give you detailed graph about your program .

abap time,database time application time ..

st05 is sql trace where it will give you individual select stmnts in your program

and also proper index is being used or not.

Other performance tips

check any select stmnts inside the loop and replace with read statement

use binary search in read stmnts

use proper index in where condition in select stmnt.

if you want to execute st05..go st05..trace on~~-execute ur program~~--come to st05..trace off and --list trace...

you get summary details of select queires and it will be pink or other color.

Thanks

Former Member — Tue, 19 Jun 2007 03:53:41 GMT

but.... Saritha

here is the good link u can find lot of info init...

it is not having huge data but what ever is there important i think.....

~~Guduri