topic Re: Performance Transactions in Application Development and Automation Discussions

Performance Transactions

Former Member — Mon, 27 Nov 2006 10:15:29 GMT

Hai All,

I am Farooq, the only individual for a Company working on ABAP from about 3 months. Please let me know all the details with Transactions of Performance Tuning, SQL Trace, & different other Traces.

Now I have come across ST01, ST02, ST03, ST04, ST05, ST06, ST07, ST11, ST14, ST20, ST22, ST30, ST33, ST35, ST36, ST37, ST62. I am hardly aware of anything in these. I know little about ST05 only & very interested to learn much more.

May be explaining all these may take much time & is not Possible here. So its OK even if U take your own time & send across any documents or mails to my ID, "shaikfarooqhussain@gmail.com" when u r free. I would be very thankful to U. THANKS a lot in advance.

Best Regards & wishes.

Farooq

Re: Performance Transactions

Former Member — Mon, 27 Nov 2006 10:26:10 GMT

Apart from that u need to check whether select stat has got all the key fields in the where clause and we should not use into corresponding fields and read table has to be used with index and binary search, field symbols has to be used wherever possible,select * should not be used, select single shuld not be used, inside the loop select statements shuld not be used, select end select shuld not be used etc...the above points will increase the performance.

Re: Performance Transactions

Former Member — Mon, 27 Nov 2006 10:29:51 GMT

Go to Se30 and check with the runtime analysis of the program to analyse.

For further help click on Tips & Tricks and enter your select queries and check for response time or execution time of the same.

Re: Performance Transactions

anversha_s — Mon, 27 Nov 2006 10:31:26 GMT

hi,

so u want to know more abt ST05

chk this.

Check this SAP help

http://help.sap.com/saphelp_nw04/helpdata/en/17/358df9c9fee2469105731e10756921/frameset.htm

rgds

Anver

Re: Performance Transactions

Former Member — Mon, 27 Nov 2006 10:52:08 GMT

Hi Farooq

There is SDN link <a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5d0db4c9-0e01-0010-b68f-9b1408d5f234">Performance tuning SAP R/3 and Oracle DB</a>

It is a very good document discussing about tools provided by R/3 and fine tuning R/3 access with Oracle DB.

Further: The SAP online help (http://help.sap.com/saphelp_47x200/helpdata/en/14/6d1c370c468b7be10000009b38f936/frameset.htm) provides comprehensive details about the other tools such as:

Debugger

Runtime Analysis

Coverage Analyzer

Runtime Monitor

Hope this helps

Cheers!!

Harsha

Re: Performance Transactions

Former Member — Mon, 27 Nov 2006 11:13:30 GMT

Also check the URL <a href="http://help.sap.com/saphelp_47x200/helpdata/en/d1/802cfc454211d189710000e8322d00/frameset.htm">Performance Trace</a> in the online help.

Cheers!

Harsha