performance analysis

[Former Member]

1.suppose a report is created , and after executing it , its response is very slow, so how can we perform performance tuning, tell the process of performance analysis and tuning.

2. how can we use abap debugger,

3, what is check point and watch point, and what is the difference

[Former Member]

Hi,

You can do the performance analysiss through transaction: SE30.

Then for improving performance, you may supply all the key fields for select queries. Use for all entries instead of subqueries, select only the fields you require etc....

For similar FAQs, pls refer to the pages in http://www.sourceveda.com/

For using the ABAP debugger:

http://help.sap.com/saphelp_nw70/helpdata/en/c6/617ca9e68c11d2b2ab080009b43351/frameset.htm

Breakpoints

In the Breakpoints area, you will see a list of all the breakpoints set so far. If one of the breakpoints has just been reached, this is marked with a yellow arrow. The visibility (Debugger, session, user) and type (line, ABAP command, …) is displayed for each breakpoint.

If you double click the Navigation() column, the system will display the breakpoint in the respective source code.

The visibility of a breakpoint can be changed through the dropdown list. To change the visibility of several breakpoints, mark them and select the pushbutton Save as Session Breakpoint or Save as User Breakpoint.

You can change the visibility of all Debugger breakpoints using the menu path Breakpoints-> Save Debugger BPs as -> ....

In addition, you have functions for creating, changing, activating and deactivating breakpoints at your disposal.

Watchpoints

In the Watchpoints area, you will see a list of all the watchpoints set so far. The watchpoint last set is highlighted with a yellow arrow.

For each watchpoint you will see not only the current value but the value before the last changed. (Technically speaking, each time you create the watchpoint and each time the watchpoint variable is changed, a clone of this variable is created.)

In this way, you can always determine what changes have been made to the monitored variable. For complicated data structures, such as internal tables or structures, select the pushbutton „Compare Variables“( ) and choose the Diff tool to compare the old and new variable values.

In addition, you have functions for creating, changing, activating and deactivating watchpoints at your disposal.

Checkpoints

In addition, you can edit conditional and unconditional checkpoints using the Breakpoints tool. This function is provided in the new Debugger only. Conditional checkpoints are set first in the source code using the ASSERTstatement; unconditional checkpoints are set using the BREAK-POINT statement. These have the effect that programs will be continued only if a preset condition is fulfilled. In the following window, these checkpoints can be searched for, activated, or deactivated.

http://help.sap.com/saphelp_nw70/helpdata/en/e2/5f5a42ed221253e10000000a155106/frameset.htm

Regards,

Renjith Michael.

Edited by: Renjith Michael on Feb 15, 2008 2:02 PM

[former_member194613]

Use the debugger to check the functionality.

Use the 2 traces to check performance:

SQL trace:

/people/siegfried.boes/blog/2007/09/05/the-sql-trace-st05-150-quick-and-easy

SE30

/people/siegfried.boes/blog/2007/11/13/the-abap-runtime-trace-se30--quick-and-easy

Siegfried