topic Re: st05 in Application Development and Automation Discussions

st05

Former Member — Fri, 09 Mar 2007 11:14:42 GMT

hi to all ,

can anybody tell me the difrence between runtime anaysis and st05.

Regards,

Kiran.

Re: st05

Former Member — Fri, 09 Mar 2007 11:17:41 GMT

they r both use to find the performance of the code.

se30 will give the runtime analysis for sql , abap n appl.

st05 will give the sql trace of all the select that u have written in the code.

u can see it table wise or sql statement wise.

ST05 – SQL trace

SE30 – Abap runtime analysis

regards,

madhu

Re: st05

Former Member — Fri, 09 Mar 2007 11:20:18 GMT

Hi Kiran,

Please refer the link,

Regards,

Hema.

Reward points if it is useful.

Re: st05

Former Member — Fri, 09 Mar 2007 11:21:18 GMT

Hi,

ST05 is the SQL Trace transaction and can be used to measure the performance of the select statements of the program.

SE30 is the Runtime Analysis transaction and can be used to measure the application performance. It also gives some tips on how to improve the performance through efficient code.

Regards,

Sruthi

Re: st05

Former Member — Fri, 09 Mar 2007 11:21:35 GMT

Hi.....

St05 is Performance trace

EX: SQL Trace...

It will Show the database table hits during a particular time by a user.

but runtime analysis will analyze a program in terms of Database usage, System time etc....

Suresh.....

Re: st05

Former Member — Fri, 09 Mar 2007 11:24:42 GMT

Hi...

Coming to <b>Transaction ST05</b> --- SQL Trace.....

Here you can Trace what are all the things that are effected in the SAP system when your code is executed....

For this you got to switch on SQL Trace.....

Like for Example you can identify all the tables that are getting modified with a simple Select Statement....

Coming to <b>Runtime Analysis....</b>

Here you can identify how much

ABAP Memory

Database Memory

System Memory

is used by the Program

Please reward if it is valuable

Regards,

Vivekananda Varma Dandu.