05-23-2006 5:51 AM
hi experts
can u plz explain what is performance tuning and how it should be done
regards
venkat
05-23-2006 5:55 AM
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
05-23-2006 5:56 AM
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
05-23-2006 6:00 AM
HI
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
05-23-2006 6:11 AM
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
05-23-2006 6:17 AM
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