topic Re: Performance Tuning in Application Development and Automation Discussions

Performance Tuning

Former Member — Fri, 21 Jul 2006 06:51:33 GMT

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.

Re: Performance Tuning

Former Member — Fri, 21 Jul 2006 06:55:12 GMT

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.

refr

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

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

rgds,

latheesh

Message was edited by: Latheesh Kaduthara

Re: Performance Tuning

Former Member — Fri, 21 Jul 2006 06:55:45 GMT

Hi,

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

Reward for helpful answer

Regards,

Shakuntala

Message was edited by: shakuntala Negi

Re: Performance Tuning

Former Member — Fri, 21 Jul 2006 06:57:26 GMT

Doc sent.

-Aarthi.

Re: Performance Tuning

Former Member — Fri, 21 Jul 2006 06:58:46 GMT

hi,

Check this link

Performance tuning for Data Selection Statement & Others

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

Re: Performance Tuning

Former Member — Fri, 21 Jul 2006 06:59:00 GMT

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

Re: Performance Tuning

Former Member — Fri, 21 Jul 2006 07:00:03 GMT

<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