topic Re: Performance analysis with SE30 in Application Development and Automation Discussions

Performance analysis with SE30

Former Member — Mon, 08 Feb 2010 07:17:17 GMT

Hi,

I want to know about performance analysis with SE30 How much should be percentage of DATABASE SYSTEM and on ABAP how to reduce the load of system and which is more critical load on DATABASE OR abap, also for my report i have checked with different parameter according to the posting period which i have selected the graph is changing

regards,

zafar

Re: Performance analysis with SE30

Former Member — Mon, 08 Feb 2010 15:03:19 GMT

There are a variety of materials on the subject of Performance Analysis and SE30. If you'll take the time to search the blogs and articles in SCN, I'm confident you'll find something useful...

Percentages vary, depending upon what we're doing, which tables we're using, how many tables, etc. So, there are no hard and fast rules about what the percentages should be (so far as I know). Generally, very high database percentages can predict long runtime if one is obtaining a large number of data rows, and suggest (to me, at least) the need to review the select statements within the ST05 trace tool, to be sure I'm utilizing index and doing so optimally for each table I'm reading, that I'm not bypassing SAP buffers if not necessary, etc.

Re: Performance analysis with SE30

vinod_vemuru2 — Mon, 08 Feb 2010 15:09:23 GMT

Hi,

Open SE30, execute your transaction/program/FM, comeback to SE30. Now click on Analyze button.

Here you can see the %time taken by database operations and ABAP logic. Click on hit list(F5) to check the detailed analysis.

Thanks,

Vinod.

Re: Performance analysis with SE30

Former Member — Mon, 08 Feb 2010 15:12:16 GMT

Data base load should be at minimum, st05 will gove u the load analysis, If u want to decrease the load, use perfoamce techniques see in menu environement eg -> examples -> performance eg.

Re: Performance analysis with SE30

Former Member — Fri, 12 Feb 2010 04:13:27 GMT