02-08-2010 7:17 AM
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
02-08-2010 3:03 PM
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.
02-08-2010 3:09 PM
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.
02-08-2010 3:12 PM
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.
02-12-2010 4:13 AM