topic performance tuning in Application Development and Automation Discussions

performance tuning

Former Member — Tue, 23 May 2006 04:51:17 GMT

hi experts

can u plz explain what is performance tuning and how it should be done

regards

venkat

Re: performance tuning

Former Member — Tue, 23 May 2006 04:55:33 GMT

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

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

check the below link

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

See the following link if it's any help:

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

Check also http://service.sap.com/performance

and

books like

http://www.sap-press.com/product.cfm?account=&product=H951

http://www.sap-press.com/product.cfm?account=&product=H973

http://www.sap-img.com/abap/more-than-100-abap-interview-faqs.htm

>http://www.techinterviews.com/?p=211

>http://sap.ittoolbox.com/documents/popular-q-and-a/abap-sample-interview

>-questions-3240

>http://www.sap-img.com/abap/answers-to-some-abap-interview-questions.htm

>http://www.geekinterview.com/Interview-Questions/SAP-R-3/ABAP

Re: performance tuning

vinod_gunaware2 — Tue, 23 May 2006 04:56:41 GMT

Runtime Analysis

Switch on RTA Dynamically within ABAP Code

*To turn runtim analysis on within ABAP code insert the following code

SET RUN TIME ANALYZER ON.

*To turn runtim analysis off within ABAP code insert the following code

SET RUN TIME ANALYZER OFF.

OR <b>SE30</b>

SQL Trace

SQL trace(ST05) provides the developer with the ability to analyse database select statements. Simply execute ST05 to turn on SQL trace, then execute the statement/program you want to analyse. Now turn off SQL trace using ST05

and click on list trace to view the details.

You can also perform traces on other items such as authorisation objects.

Authorisation trace analysis

1. Open two sessions

2. Execute transaction ST01 in one of the sessions

3. Select the authorisation checkbox, note the other traces

you can perform (SQL, RFC, Table Buffer etc)

4. Click the 'Trace On' button

5. Within your other session execte the transaction/report

you want to trace or get the user in question to do it

6. Return to the session where you turned the trace on and

click on 'Trace Off' otherwise it will continue to record all athorisation checks

7. Click on the 'Analysis' button

8. Enter appropriate data into selection screen such as

Username, type of trace records (i.e. Authorization check)

9. Click on the Execute button.

10. Report displaying trace results will now be displayed

regards

vinod

Re: performance tuning

Former Member — Tue, 23 May 2006 05:00:01 GMT

GOOD

GO THROUGH THIS

Tools provided for Performance Analysis

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.

The WHERE clause in the trace list's SQL statement is different from the WHERE clause in the ABAP statement. This is because in an R/3 system, a client is a self-contained unit with separate master records and its own set of table data (in commercial, organizational, and technical terms). With ABAP, every Open SQL statement automatically executes within the correct client environment. For this reason, a condition with the actual client code is added to every WHERE clause if a client field is a component of the searched table.

To see a statement's execution plan, just position the cursor on the PREPARE statement and choose Explain SQL. A detailed explanation of the execution plan depends on the database system in use.

SAP Performance Tools

Runtime Analysis

SQL Trace

Internal Table Performance Improvements

using Parallel cursor

Using GroupBy

GO THROUGH THIS LINK TO KNOW FURTHER DETAILS

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

THANKS

MRUTYUN

Re: performance tuning

Former Member — Tue, 23 May 2006 05:11:45 GMT

Hai Venkat

Go through the following Link that will give better for you

this link having documentation along with Good Examples

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

Thanks & regards

Sreenivasulu P

Re: performance tuning

Former Member — Tue, 23 May 2006 05:17:55 GMT

Hi Venkat,

Good Question,

Performance Tuning is useful mainly reducing load on database. It is very important aspect while writing the programs/FM etc.....

Here are the following ways to find the Performance Tuning:

1. SE30 Runtime Analysis , here you can find the load on database

2. SLIN Extended Program Check

3. ST05 SQL Trace

4. Specical care while writing SQL statements

5. Declare the Internal tables without Headerline

6. Avoid unnecessary Variables/constants...

7. Use Primary keys wherever necessary

8. Use FMs at necessary places.

Please reward points

Regards

Prabhu