topic Re: difference between se30 and st05 in Application Development and Automation Discussions

difference between se30 and st05

Former Member — Thu, 31 May 2007 19:09:42 GMT

hi experts,

what is the difference between runtime analysis and sql trace.

Thanks,

Samanvi.

Re: difference between se30 and st05

Former Member — Thu, 31 May 2007 19:15:35 GMT

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

Re: difference between se30 and st05

Former Member — Thu, 31 May 2007 19:15:35 GMT

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

Re: difference between se30 and st05

Former Member — Thu, 31 May 2007 19:39:26 GMT

Hi Samanvi,

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

Reward if useful.

Thanks

Aneesh.

Re: difference between se30 and st05

Former Member — Fri, 01 Jun 2007 00:57:24 GMT

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