‎2007 Feb 12 10:36 AM
Hi friends,
I want to know briefly about <b>performance analysis</b> with suitable examples.
Please i dont want study materials or links.
reward sure if it is helpful to me.
Thanks in Advance
‎2007 Feb 12 10:43 AM
Hi,
<b>SQL trace(ST05)</b> 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.
<b>Authorisation trace analysis</b> 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
Hope this helps.
Reward if helpful..
Regards,
Sipra
‎2007 Feb 12 10:45 AM
Also look at transction SE30, then choose Hints+Tips. This has good examples of performance enhancing code.
‎2007 Feb 12 10:52 AM
‎2007 Feb 12 10:55 AM
Hello,
ABAP Performance Trace (ST05)
ABAP Runtime Trace (SE30)
Vasanth
‎2007 Feb 12 11:04 AM
Hi senthil if u need material mention ur mail id.i can send to u
‎2007 Feb 12 11:10 AM
along with se30
sql trace
u can also enhance & analyse u r program through
ABAP cross reference analysis: RSINCL00
Unused variable
Unused program parts
Incorrect interfaces
Report RSINCL00 can analyze an ABAP program and generate some very good information such as unused variable, unused program parts, incorrect interfaces, functions used, ...etc.
‎2007 Feb 12 11:45 AM
Hi,
For performance tuning steps,you can try transaction ST05 for SQL Performance trace.For ABAP runtime anaysis,try se30.You can execute your program and then check the DB and ABAP access which is greatly beneficial for performance tuning.Further, check "tips and tricks" in se30.You can find some efficient ways of coding.
Regards,
Beejal
**Reward if answer is helpful