Performance Transactions

[Former Member]

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 <b>ST01, ST02, ST03, ST04, ST05, ST06, ST07, ST11, ST14, ST20, ST22, ST30, ST33, ST35, ST36, ST37, ST62</b>. I am hardly aware of anything in these. I know little about <b>ST05</b> 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. <b>THANKS a lot in advance.</b>

Best Regards & wishes.

Farooq

[Former Member]

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.

[Former Member]

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.

[anversha_s]

hi,

so u want to know more abt <b>ST05</b>

chk this.

Check this SAP help

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

rgds

Anver

[Former Member]

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

[Former Member]

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