‎2007 May 17 11:40 AM
hai...Have you used performance tuning? What major steps will you use for these?
‎2007 May 17 12:49 PM
Hi ,
Performance tuning is very very important stage otherwise ur program will take a long time to get the data and on the database also their will be very much load after execution .
the steps of performance tunung are ,
1. Use all selection screen parameters in ur where clause,
2.dont use select *,
3.use select single
4. make one view for the fields u want to populate
these are some of the performance tuning points.
<b>DONT FORGET TO REWARD</b>
REGARDS
FAREED
‎2007 May 17 11:47 AM
hi,
chk this. very useful.
http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp
https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abapPerformanceand+Tuning&
http://www.erpgenie.com/abap/performance.htm
http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm
https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abapPerformanceand+Tuning&
http://help.sap.com/saphelp_nw2004s/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/frameset.htm
http://help.sap.com/saphelp_nw2004s/helpdata/en/d1/801f7c454211d189710000e8322d00/frameset.htm
Regards
Reshma
‎2007 May 17 11:50 AM
HI,
http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp
Performance tuning for Data Selection Statement
http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm
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
Run Time Analyser
http://help.sap.com/saphelp_47x200/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/content.htm
SQL trace
http://help.sap.com/saphelp_47x200/helpdata/en/d1/801f7c454211d189710000e8322d00/content.htm
CATT - Computer Aided Testing Too
http://help.sap.com/saphelp_47x200/helpdata/en/b3/410b37233f7c6fe10000009b38f936/frameset.htm
Test Workbench
http://help.sap.com/saphelp_47x200/helpdata/en/a8/157235d0fa8742e10000009b38f889/frameset.htm
Coverage Analyser
http://help.sap.com/saphelp_47x200/helpdata/en/c7/af9a79061a11d4b3d4080009b43351/content.htm
Runtime Monitor
http://help.sap.com/saphelp_47x200/helpdata/en/b5/fa121cc15911d5993d00508b6b8b11/content.htm
Memory Inspector
http://help.sap.com/saphelp_47x200/helpdata/en/a2/e5fc84cc87964cb2c29f584152d74e/content.htm
ECATT - Extended Computer Aided testing tool.
http://help.sap.com/saphelp_47x200/helpdata/en/20/e81c3b84e65e7be10000000a11402f/frameset.htm
Just refer to these links...
You can go to the transaction SE30 to have the runtime analysis of your program.Also try the transaction SCI , which is SAP Code Inspector.
Regards,
Priyanka.
‎2007 May 17 12:49 PM
Hi ,
Performance tuning is very very important stage otherwise ur program will take a long time to get the data and on the database also their will be very much load after execution .
the steps of performance tunung are ,
1. Use all selection screen parameters in ur where clause,
2.dont use select *,
3.use select single
4. make one view for the fields u want to populate
these are some of the performance tuning points.
<b>DONT FORGET TO REWARD</b>
REGARDS
FAREED
‎2007 May 17 1:48 PM
‎2007 May 31 6:59 AM