Performance analysis of report or transaction

[Former Member]

Hello Experts,

How do we analyse the performance of a report or a transacton in SAP. I want to know thetransactions and the steps that needs to be followed in order to get this.

points are guaranteed...

thanks

sankar

[Former Member]

hi,

SE30 - gives you a run time analysis and points out the issues more at design time.

ST05 - Is the most useful if you want to track time taken for execution of each of the sections.

SM50 - Will give you a work process overview, not sure at a program level how can it help you.

Some times you will have to use a combination of SE30 and ST05.

I would like to use St05 personally.

SQL Trace (ST05) we use for performance tuning

In se38,you have a report and you want to test the performance of that report

ST05 tells about the summary of sql statements used in that program.

-Go to Tcode ST05

-Select Trace on

-In se38,Execute your report-

-Come back to st05 and select Trace off

-Select Trace list.

Now you check your select stmnts and how much time taking

-Some columns showing pink color are expensive select stmnts

You have so many options inside to check for summary and also index..

http://help.sap.com/saphelp_47x200/helpdata/en/f2/31adaa810c11d288ec0000e8200722/frameset.htm

ST02 --> Memory management

ST03 --> Dialog Service

OS06 --> Operating System

SCI --> Code Inspector

Regards

Reshma

[Former Member]

HI

IN YOUR REPORT PROGRAM AFTER ACTIVATING

GOTO THIS PATH

PROGRAM -> CHECK -> CODE INSPECTOR OR EXTENDED PROGRAMING CHECK

IF CLICK ON THIS YOU WILL GET ERRORS , WARNINGS AND SOME OTHER

IF YOU MAKE ALL THESE POINTS AS ZERO THEN THAT PROGRAM IS GOOD IN THE PON=INT OF PERFORMANCE POINT OF VIEW

IN THIS YOU WILL FIND DESCRIPTION OF THAT ERROR ALSO

REWARD IF USEFUL

REGARDS

NARESH '

[Former Member]

Hi,

You could use ST05 for performance analysis. This is an SQL trace which will return all the details of the table fetch done by the program.

Regards,

Shruthi R

[Former Member]

Hi,

For performance issues you can use the following transactions:

SE30 - This transaction will give you a brief description of the time and load on the database and ABAP and system while performing a certain task

ST05 - This transaction will give you a detailed description of each and every statement that is processed while executing a particular task. In this you can see statements with different color codes. If you see a statement in RED colour , this means that it is taking more time than it should take. It would take a lot of time in analyzing the report generated by ST05 ..

Br,

Harmeet

reward points if useful

[Former Member]

You can go in for Code Inspector or extended program checks.

Also se30 - Runtime analysis helps in performance analysis.

ST05 also comes handy.

Thanks

swarna