performance tcode

[Former Member]

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

Regards

Rajaram

[Former Member]

ST05, DB02

[Former Member]

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

[Former Member]

Hi Raja Ram

SQL Trace ST05 can also be used..

Regards,

Arun

[Former Member]

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.

[Former Member]

hi,

try with this Tocdes

ST05 -

---

SQL QUERY ANALYSIS [ PERFORMANCE ANALYSIS ]

ST30 -

---

GLOBAL PERFORMANCE ANALYSIS

if helpful reward some points.

with regards,

Suresh Aluri.

[Former Member]

can you please explain how to work on st05 and st30

[Former Member]

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.