Categories Uncategorized [SAP] SAP Performance Tuning – Part I – The theoretical approach November 21, 2011 | 167 Views | Stefan Koehler more by this author Retagging required Performanceperformance and scalability share share tweet share like 0 Follow Moved, extended and consolidated to [Oracle / SAP] Thinking clearly about performance and why ASH / AWR based analysis may not be the right approach Alert Moderator To report this post you need to login first. 8 Replies 8 Comments You must be Logged on to comment or reply to a post. Former Member November 21, 2011 at 4:30 am Hello Stefan,thanks for the blog, it provides a good overview! I don’t do performance tuning regularly, so maybe I am only missing some information. For example when I see in STAD that RFC processing was done, I am stuck. Which ABAP code was executed? RFC. Wow, that is the hell of an answer! Maybe with a higher tracelevel I could get that information, but what to do for a post-mortem analysis? Also, personally I don’t really like the SAP “out-of-the-box” metrics. There is some basic automatic recording of metrics and luckily often they point into the right direction. But what if the standard metrics won’t suffice? Then I need either external tools or additional information like higher tracelevels and I am completely on my own for doing an analysis. (Seems like trace data is meant for SAP support and SAP support only.) If I compare the situation with Oracle database performance metrics, the situation is much better. There are many books which explain the Oracle wait events and how to analyze performance.Interestingly the situation now changes and the AWR data for Oracle is getting deactivated because customers buy Oracle licenses directly at Oracle. To save some money, the best part of Oracle isn’t licensed any more! But now I am getting off-topic. Regards, Mark like (0) Stefan Koehler Post authorNovember 21, 2011 at 5:03 am Hello Mark,thanks for your reply. > Which ABAP code was executed? RFC Wow, that is the hell of an answer!There is a section called “Remote Function Calls” in STAD, which provides that kind of information. In my experience most people also don’t know that calling ABAP functions can force an internal RFC call. > But what if the standard metrics won’t suffice?There are also several (dynamic) SAP init parameters which can be set to track these (rare) cases. So it’s not some kind of tracing – the measurement will just include more information (for example in STAD). As i already mentioned – my next blog in this series will be about how to identify a performance issue for a specific transaction. I planned to focus on drilling down to a DB related issues (which are the most in my experience), but maybe i am also able to build up a test case for a RFC issue. Best RegardsStefan like (0) Former Member November 22, 2011 at 2:58 am Hello Stefan,thanks for the tip about the RFC details. Now I can at least see for individual RFC steps which code was running.Regards,Mark like (0) Former Member November 22, 2011 at 12:25 am As always the struggle with performance is an ongoing battle. I’m an ABAP programmer, and can’t even begin to count the times I’ve looked at performance issues. This is usually after our system (“Basis”) folks have pointed me in the correct direction. like (0) Stefan Koehler Post authorDecember 12, 2011 at 9:22 am Dear followers,i am sorry for the delay of the second part in this blog series. I waited for the new SDN platform and wanted to use the new blog UI, because of the amount of images and pointers in the next blog. Now i have to struggle with the old blog UI and i hope i will get it until the end of the week. Stay tuned. Best RegardsStefan like (0) Ambarish Satarkar March 14, 2013 at 1:27 pm Hello Mr. Stefen, First of all thanks to you for this easy to understand blog.May be its too late to ask but actually I was very keen to go through your second part. It will be great if you could post the link here. May be everyone can get the benefit. Regards, Ambarish like (0) Eduardo Rezende July 16, 2013 at 8:11 pm Hi Stefan, Very good and detailed blog! Regards, Eduardo Rezende like (0) Deepak Kori July 17, 2013 at 1:39 am Hi Stefan, It is a good approach document on Performance tuning. Regards, Deepak Kori like (0) Leave a Reply Cancel replyYou must be logged in to post a comment.