difference between se30 and st05

[Former Member]

hi experts,

what is the difference between runtime analysis and sql trace.

Thanks,

Samanvi.

[Former Member]

<b>runtime analysis</b> shows the performance of the program or transaction by showing the usage of tables, internal tables, FM call and methods....

<b>sql trace</b> shows you all the regarding SELECT statements and on which tables they have been applied...

Greetings,

Blag.

[Former Member]

Hi,

Both are used to find the performance of the codes.

SE30 will give the runtime analysis for sql, abap and appl.

ST05 will give the sql trace of all the select that you have written in the code.

You can see it table wise or sql statement wise.

Regards,

Ferry Lianto

[Former Member]

Hi Samanvi,

Go thru this link. It gives a lot of information.

Reward if useful.

Thanks

Aneesh.

[Former Member]

Both are using one purpose and will have minor diffrence.

SE30 - will give run time process and it will have abap memory,sap memory and data base execution graph..

St05 - SQL Trace - it will trace each query in a transaction,suppose transaction is running more than one hour and you want to tune the program.

just goto ST05 Transaction and click on trace on.now enter ur transaction and run ur transaction.once you done then comeback and trace off,list trace.

now it will show time - corresponding query,then we can use performance tuning to each query