Performmance

[Former Member]

Hi ,

From which transaction i can analyze the performance of my ABAP report ?

SE30->STO5-> Correct ?

What is the corect sequnc to analyze / Test any ABAP report

[Former Member]

Hi

Use SE30 for Run time analysis, do it and analyse.

ST05 is meant for SQL trace.

reward if useful

regards

Anji

[Former Member]

Hi,

Execute ST05 transaction

Set the Trace on

In parallel session, run the program

Once the program is executed & output displayed, set the trace off

Then click on display trace

Best regards,

Prashant

[Former Member]

In SE30>Give the program name>

Execute the program.

And click on Analyse button.

also chk this

http://www.sap-basis-abap.com/sapta002.htm

[Former Member]

st05 is for sql trace..

to have ur report perfornance use se30..it will help u better..

if u want to know the flow of ur sql statements in deatils use st05

regards,

[Former Member]

Hi Kumar,

SQL trace provides the developer with the ability to analyze database select statements. Execute Tcode ST05 > Turn on SQL trace, then execute the program which you want to analyze. > Turn off trace. > Click on list trace to view the details.

Make use of these tranactions.

ST01 SAP systems trace

ST02 Buffer statistics.

ST03 Workload analysis.

ST04 Database performance analysis.

ST05 SQL trace.

ST06 Operating system monitor

Check Below Links,

http://help.sap.com/saphelp_erp2005/helpdata/en/d1/801f89454211d189710000e8322d00/content.htm

http://www.sapbrain.com/TOOLS/SQLTRACE/SQL_TRACE.html

http://www.sapdevelopment.co.uk/perform/perform_sqltrace.htm

Regards,

Suresh.

[aris_hidalgo]

Hi Kumar,

Aside from SE30(Runtime Analysis) and ST05, there are a couple of things you might want to do. You can use Extended Program Check, Code Inspector, Generation Limit, etc. All ofthese can be accessed from SE38->type in your program name then click the PROGRAM tab in the upper left portion of your screen->CHECK. These tools will help you analyze and determine what is lacking in your SQL statements, obsolete statements, data declarations that are not being used, etc. By doing these things, it will help your program in terms of performance, keep it up-to-date, etc.

Hope this helps...

P.S. Please award points if it helps...

[Former Member]

Hi,

To Analyse your Program Use the Transaction SE30.

Reward Points if it is helpful.

Regards,

Sangeetha.A

[Former Member]

Hi,

U can go to the following Tcodes inorder to analyze the performance of a report

ST05 - Sql tracer

SE30 - Run Time Analysis

AL21 - used to analyze perofrmance of a Program.