topic Re: Performance Tuning Template in Application Development and Automation Discussions

Performance Tuning Template

abapdeveloper20 — Mon, 02 Jun 2008 06:43:40 GMT

Hi Experts,

Is there any specfic template/ documents for documenting the tuned programs????

i.e any specification documents like Functional Specfication , technical specification..

Any useful replies will be rewarded points.

Thanks in advance

Rgds

Lakshmiraj A

Re: Performance Tuning Template

Former Member — Mon, 02 Jun 2008 06:48:46 GMT

Hi,

you do not have any FS or TS for performance tuning. it is waht u have to do it in the program u create based on ur FS and TS. if u want any hints, then there are lots.

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/abap%2bperformance%2band%2btuning

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/abap%2bperformance

is this wat u r looking for?

regards,

madhu

Re: Performance Tuning Template

abapdeveloper20 — Mon, 02 Jun 2008 06:54:57 GMT

Hi Madhumita,

Thanks for the reply.

Actually I'm looking some kind of documents to show the results comparision of the actual program and tuned program... like previous execution ...variants selection....

is there anything available???

Rgds

Lakshmiraj Angamuthu

Re: Performance Tuning Template

Former Member — Mon, 02 Jun 2008 06:58:06 GMT

Hi!!

Try reading this

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

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

few tips:

1.Kindly see if u have mistakenly using select-endselect.

2.using select queries widin loop-endloop.

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

4.considering performance we should try writing such code which hits database min number of times.

If the database percentage is less(min) ur code's perforamnce is better.

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

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

Or else above mentioned links gives details about the performance tuning.

Hope this helps .Kindly rewrd if useful.

Re: Performance Tuning Template

Former Member — Mon, 02 Jun 2008 06:58:45 GMT

Hi,

I have done such a thing, but not via programming.

we actually create a copy of the actual prog. tune the copied one. run those 2 programs via se30 and st05 for the same vairant. document the screen of se30 and st05 for both the progs. vairant selection can be captured in se30. this way u can compare 2 programs.

i'm not aware program execution comparison other way around!!!

regards,

madhu

Re: Performance Tuning Template

abapdeveloper20 — Mon, 02 Jun 2008 07:04:18 GMT

Hi,

Yes...I hope that document will help me.

Can you pls send me any one of those documented file with se30 & st05 screens to me??? It will be great help.

My id : lakshmiraj43 at yahoo dot com

Thanks in advance.

Rgds,

Lakshmiraj

Re: Performance Tuning Template

Former Member — Mon, 02 Jun 2008 07:09:03 GMT

hi,

it is not possible to send it as the doc is confidential. but i can create a template for u. but need some time!!!

regards,

madhu

Re: Performance Tuning Template

Former Member — Wed, 04 Jun 2008 09:35:06 GMT

Hi madhu

Pls send that document to me