performance tuning

[Former Member]

Hi-everybody <b>how to perform the following tasks:</b>

IN PERFORMANCE TUNING.

1.utilizing SAP's tools for monitoring ABAP performance

2.systematically analyzing ABAP Performance problems

3.solving ABAP performance problems that CAUSE

i.High database load (frequent accesses to the database)

ii.High CPU load (frequent accesses to internal tables

THANKS IN ADVANCE.

[RichHeilman]

First you can do a SQL trace using transaction ST05, this will give you an idea of what SELECT statements are taking more time, then you can analyze the program code and modify the SELECT statements.

Regards,

Rich Heilman

[Former Member]

3i) Make sure selects are using indexes effictively.

3i) Avoid nested loops (and other nested functions that take time, like RFCs)

Rob

[Former Member]

Hi Nagini,

If you are monitoring performance of a job, You can go to job details and get the PID of the job (In SM37 double click on the job).

Then go to ST04 > detailed analysis menu > Oracle session

Here if you search using the PID, you will be able to see what kind of database activity is being done by the job.

Keep refreshing on the screen for updates.

You can also do this for programs run in fore ground by searching for the PID in SM50.

Hope this solves.

Regards,

Sameer

[Former Member]

it's useful also to check top DB requests, top time in ST03, STAT transaction can help as well to analyze performance, you can check STUN transaction which is performance monitoring.

The tools mentioned in previous posts can really help when you identified process/program which is causing performance problem, you can determine what exactly is causing it by using those tools (SQL trace, SM50, thread activity in ST04 for your process is available,...)

[rui_nunes]

Hi,

You can also use SE30 - Runtime Analysis.

Select transaction, program or function module you want to test, when the process is complete you get a graphic with time spent between ABAP, Database and System.

You can still go to the details and get a complete list of all programs, modules and database accesses with the % resource consumption. For any entry, you can also go directly to the code behind it.

Hope it helps, regards,

Rui