ST12 issue

[Former Member]

Dear Experts,

I am having trouble in understanding ST12.

I used it for one of my programs, it gave me this statistics

After some tuning(Like hitting MSEG with proper where conditions), again I ran the program. It is giving me these statistics

After again some tuning(like sorting some tables and using the Binary Search in Read statements), it gave me these statistics.

I did not understand whether my program performing well or not since there are no exact statistics of time which is varying.

Please make me understand, ABAP, DATABASE and SYSTEM in ST12.

Regards,

G.V.S Praveen Kumar

[Former Member]

Hi Praveen,

This graph is showing you the execution time of

1- ABAP Operation (your business logic)

2- Database Operation (Select, Modify, Update, Delete...all database related operations, mainly Select)

3- System Operation (You don't have control over it in most of the cases)

Red color shows that it is taking more time than expected. Green color shows that it is taking

adequate time to execute the statements.

Now, if we look at your first screen shot, it is showing that database part is taking much time. This is the place where you should focus to improve the program performance.

Analyze the trace for database operations, SELECT...

and try to optimize them. Currently your database execution time is 69.6 % of total (100%) of your report.

Hope it helps you to understand the concept.

[Former Member]

Thnks for ur reply,

I have done some changes and given u screen shots.

Can u pls. eloborate about next 2 screen shots.

Incase of 3rd screen shot. I hope Sort will not give any performance issue since database got increased again

Regards,

Praveen

[Former Member]

Hi,

Now focus on reducing the database load. For this in ST05, once you run the transaction, Deactivate the trace, and click on display trace.

Now go to Trace List --> Summarize Trace by SQL Statement

now Click on Duration column and Sort it in decending order. Now consider the top 10 or top 15 operations to optimize your code.

Hope it helps you!

[ThomasZloch]

I never look at these percentages, as they are pretty meaningless. Depending of what your program actually does, it might well be OK to have 90% database (mostly SQL statements) or 90% ABAP processing (e.g. internal table handling).

The question is, does your program run longer than desired? If yes, then study the ABAP Trace of ST12, sort the list by net time descending, focus on the top few items, these are very often inefficient DB accesses or itab handling that can be enhanced.

Thomas

[Former Member]

Hi,

Ok then, I will not use this ST12 anymore as there is no use Instead we can use st05 to trace queries.

Thanks

Regards,

Praveen

[ThomasZloch]

No no, ST12 is great, it combines the essential ST05 and SE30/SAT features (at least in the version I'm looking at, are you working in an older release?), just don't look at this percentages screen, rather go the so-called "hit list" of single processing blocks. Look for the many great blogs about ST12 here on SCN.

Thomas

[Former Member]

Hi Praveen,

Please concentrate on reducing the load on the database. The database fetching would affect your script's performance a great deal. Try to keep this component as minimum as possible. Also don be under the impression that a good performance tuned script would have all the components in green.

Hope you get a better picture now.

-Regards,

Ragavan