topic Performmance in Application Development and Automation Discussions

Performmance

Former Member — Mon, 30 Apr 2007 06:46:17 GMT

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

Re: Performmance

Former Member — Mon, 30 Apr 2007 06:47:37 GMT

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

ST05 is meant for SQL trace.

reward if useful

regards

Anji

Re: Performmance

Former Member — Mon, 30 Apr 2007 06:48:01 GMT

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

Re: Performmance

Former Member — Mon, 30 Apr 2007 06:48:27 GMT

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

Re: Performmance

Former Member — Mon, 30 Apr 2007 06:48:28 GMT

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,

Re: Performmance

Former Member — Mon, 30 Apr 2007 06:49:49 GMT

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.

Re: Performmance

aris_hidalgo — Mon, 30 Apr 2007 07:00:35 GMT

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

Re: Performmance

Former Member — Mon, 30 Apr 2007 07:07:38 GMT

Hi,

To Analyse your Program Use the Transaction SE30.

Reward Points if it is helpful.

Regards,

Sangeetha.A

Re: Performmance

Former Member — Mon, 30 Apr 2007 07:28:28 GMT

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.