topic Re: ST12 issue in Application Development and Automation Discussions

ST12 issue

Former Member — Fri, 24 May 2013 10:46:38 GMT

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

Re: ST12 issue

Former Member — Fri, 24 May 2013 11:11:04 GMT

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.

Re: ST12 issue

Former Member — Fri, 24 May 2013 11:20:25 GMT

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

Re: ST12 issue

ThomasZloch — Fri, 24 May 2013 11:28:56 GMT

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

Re: ST12 issue

Former Member — Fri, 24 May 2013 11:34:54 GMT

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

Re: ST12 issue

Former Member — Fri, 24 May 2013 11:45:05 GMT

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

Re: ST12 issue

ThomasZloch — Fri, 24 May 2013 12:15:52 GMT

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

Re: ST12 issue

Former Member — Mon, 27 May 2013 04:08:21 GMT

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!