Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

DB buffer and SE30 performance analysis

Former Member
0 Kudos

Hi, I want to analyse the performance of my FM with SE30. The first time i called the FM, it took quite long time, as expected. The next time it ran very quickly, probalbu because of some buffers? How can I clear these buffers, so my SE30 performance analysis can be trusted?

Edited by: Vijay Babu Dudla on Apr 29, 2009 8:45 AM

Moderator message - Moved to the correct forum

Edited by: Rob Burbank on Apr 29, 2009 11:32 AM


Former Member
0 Kudos


please run the sql trace using ST22. it will give u a better picture.

Former Member
0 Kudos


Edited by: Vijay Babu Dudla on Apr 29, 2009 8:44 AM

Active Contributor
0 Kudos

Don't clear the buffers, run the trace several times and discard the first measurement, trust and compare the other ones.

Buffering is happening in the production system anyway, so you probably want to analyse under realistic conditions.


Active Contributor
0 Kudos

this is a common misunderstanding, the trusted includes the complete system, i.e. the usage of the buffer mainly the table buffers, plus program buffers and also the database caching of indexes and your wanted table content.

Performance problems appear if programs run slow again and again ...

A one time event of a slow execution must be accepted.