topic Re: performance tcode in Application Development and Automation Discussions

performance tcode

Former Member — Thu, 18 Oct 2007 05:30:36 GMT

Is there any other transaction except SE30 to check the performance of the report,

Regards

Rajaram

Re: performance tcode

Former Member — Thu, 18 Oct 2007 05:32:11 GMT

ST05, DB02

Re: performance tcode

Former Member — Thu, 18 Oct 2007 05:32:28 GMT

Hi,

you can use ST05 to do the SQL Trace and check whether the SQLs are using proper index or not..If the SQL is not using proper index..Then the performance of the program might not be good..

Thanks

Naren

Re: performance tcode

Former Member — Thu, 18 Oct 2007 05:32:52 GMT

Hi Raja Ram

SQL Trace ST05 can also be used..

Regards,

Arun

Re: performance tcode

Former Member — Thu, 18 Oct 2007 05:33:40 GMT

Hi,

You can use Transaction ST05 - Performance Trace

In this, you need to first activate the Trace,

then execute your program and go back to deactivate

then analyze the execution details..

Regards,

Samson Rodrigues.

Re: performance tcode

Former Member — Thu, 18 Oct 2007 05:35:03 GMT

hi,

try with this Tocdes

ST05 -

SQL QUERY ANALYSIS [ PERFORMANCE ANALYSIS ]

ST30 -

GLOBAL PERFORMANCE ANALYSIS

if helpful reward some points.

with regards,

Suresh Aluri.

Re: performance tcode

Former Member — Thu, 18 Oct 2007 06:02:49 GMT

can you please explain how to work on st05 and st30

Re: performance tcode

Former Member — Thu, 18 Oct 2007 06:15:59 GMT

Hi,

Like i said above,

You need to first ACTIVATE the trace,

then open a new window and execute your program,

After the execution is completed, go back to the Trace window and

click on DEACTIVATE Trace,

Then finally click on DISPLAY trace and Click OK on the PopUp

You can see the Database fetches and their duration that the program took.

P.S. always DEACTIVATE the Trace after you have finished else the Server may still

continue to Trace for no Reason.

Regards,

Samson Rodrigues.