‎2007 Aug 13 7:03 AM
Hi,
How I can do a performance analysis of a particular report.
Pls explain.
‎2007 Aug 13 7:05 AM
‎2007 Aug 13 7:05 AM
Hi,
Go to SE30 and give the program name and execute it.
Regards
Kannaiah
‎2007 Aug 13 7:08 AM
there are other links too..
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
http://sap.genieholdings.com/abap/performance.htm
http://www.dbis.ethz.ch/research/publications/19.pdf
Regards,
aparna
‎2007 Sep 13 12:16 PM
Hi Aparna,
You seams to have lot of helpfull information. May I ask if you got any information on Roor Cause analysis for Enterprise Portals. If so can you please send me.
Regards
Maruti CR
‎2007 Aug 13 7:34 AM
Hi Neha
Use transaction se30 and do analysis
or put a statement
get runtime and measure the time b/w all select satement and findout the diff
reward points to all helpful answers
kiran.M
‎2007 Aug 13 7:36 AM
Hi
reward if usefull
YOU have 2 ways to do performance analysis
1) after activating ur program
follow thi spath
program -> check -> extended Programing Check
or
code inspector
in this u will get errors warinings etc..
if u maintain all the erors and warining etc.. to zero then ur program will be very good in performance point of view
the error or warining description will be there
2) by going to SE30
entyer program name and click on execute
and come back again to initial screen
click on analysis and etc..
‎2007 Aug 13 7:38 AM
HI,
Go to SE30 and give the program name and execute it.AND PRESS EVALUTE BUTTON.THAT WILL SHOW U PERFORMANCE GRAPH.
rEWARDS POINTS iF IT uSEFUL
‎2007 Aug 13 7:40 AM
hi neha,
do the run time analysis in se30,before that if it is a report please avoid the following things,
1.dont use select single inside a loop.
2. dont use * in select statement instead u can use what are the fields u want
and avoid here into corresponding fields.
3. always work area
‎2007 Aug 13 8:04 AM
Hi,
I wanted to totally change one select query in runtime while fetching the records from table using SE30. Is it possible to do using that transaction??
‎2007 Aug 13 8:38 AM
Hi Neha Gupta,
Select statements performances you can check in ST05,
and you can change Select statement while runtime in ST05, check it here.
thanks
hari