Performance Tuning

[Former Member]

hi,

Any body has the documentation about performance tuning.

if any body has please send it to my mail or send me the links.

my mail id is fractal_27@yahoo.com

thanks,

fractal.

[Former Member]

Hi,

Following are the different tools provided by SAP for performance analysis of an ABAP object

Run time analysis transaction SE30

This transaction gives all the analysis of an ABAP program with respect to the database and the non-database processing.

SQL Trace transaction ST05

The trace list has many lines that are not related to the SELECT statement in the ABAP program. This is because the execution of any ABAP program requires additional administrative SQL calls. To restrict the list output, use the filter introducing the trace list.

The trace list contains different SQL statements simultaneously related to the one SELECT statement in the ABAP program. This is because the R/3 Database Interface - a sophisticated component of the R/3 Application Server - maps every Open SQL statement to one or a series of physical database calls and brings it to execution. This mapping, crucial to R/3s performance, depends on the particular call and database system. For example, the SELECT-ENDSELECT loop on the SPFLI table in our test program is mapped to a sequence PREPARE-OPEN-FETCH of physical calls in an Oracle environment.

<b>refr</b>

http://www.sapgenie.com/abap/performance.htm

http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_SelectionCriteria.asp

rgds,

latheesh

Message was edited by: Latheesh Kaduthara

Message was edited by: Latheesh Kaduthara

[Former Member]

Hi,

I have send you the related document it will definitely help you.

<b>Reward for helpful answer</b>

Regards,

Shakuntala

Message was edited by: shakuntala Negi

[Former Member]

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/10/6d1c370c468b7be10000009b38f936/frameset.htm">Here</a> is a list of the various performance analysis tools avbl in SAP.

Hope this helps.

Sudha

[Former Member]

Doc sent.

-Aarthi.

[Former Member]

hi,

Check this link

<b>Performance tuning for Data Selection Statement & Others</b>

http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm

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

http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp

http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_Introduction.asp

1. Debugger

http://help.sap.com/saphelp_47x200/helpdata/en/c6/617ca9e68c11d2b2ab080009b43351/content.htm

http://www.cba.nau.edu/haney-j/CIS497/Assignments/Debugging.doc

http://help.sap.com/saphelp_erp2005/helpdata/en/b3/d322540c3beb4ba53795784eebb680/frameset.htm

2. Run Time Analyser

http://help.sap.com/saphelp_47x200/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/content.htm

3. SQL trace

http://help.sap.com/saphelp_47x200/helpdata/en/d1/801f7c454211d189710000e8322d00/content.htm

6. Coverage Analyser

http://help.sap.com/saphelp_47x200/helpdata/en/c7/af9a79061a11d4b3d4080009b43351/content.htm

7. Runtime Monitor

http://help.sap.com/saphelp_47x200/helpdata/en/b5/fa121cc15911d5993d00508b6b8b11/content.htm

8. Memory Inspector

http://help.sap.com/saphelp_47x200/helpdata/en/a2/e5fc84cc87964cb2c29f584152d74e/content.htm

[Former Member]

HI Ger,

Here are some links useful for you,

<a href="http://sap.genieholdings.com/abap/performance.htm">http://sap.genieholdings.com/abap/performance.htm</a>

<a href="http://www.dbis.ethz.ch/research/publications/19.pdf">http://www.dbis.ethz.ch/research/publications/19.pdf</a>

Hope this willbe helpful.

🐵

Cheers,

Prashanth K.R