My previous post – “SAP ST12 Trace – SQL performance analysis” mentions that we can use mass/array database operation to replace many individual execution of the same SQL to improve database access performance. This blog will go through a true business case where a code has been changed to use array/mass SQL deletion to replace…
All posts by eric
SAP ST12 Trace – SQL performance analysis
This post is to continue my writing on how to tune a SAP program/application performance based on SAP ST12 traces. My previous post is writing about overall SAP program performance tuning process and how to analyze ST12 ABAP trace to improve SAP program/application performance. Here, I would cover how to analyze SAP ST12 SQL trace…
Why would SAP job runtime suddenly jump well above normal range?
Business was complaining that runtime of a periodic SAP background job was suddenly jumped in production environment. There is no code change and no volume change and other jobs and transactions are running well. They were asking why this happened. I was consulted and looked into the situation. Finding the issue was related to Oracle…
What types of SAP performance analysis can we do using SAP ST03N transaction?
In my previous post, I talked about how to do navigate through various analysis views of SAP ST03N transaction. In this post, I would give an introduction on typical types of performance analyses which I have used SAP ST03N for in my work. Who is placing workload into a SAP system and when/where/how is SAP…
SAP migration and performance – Would use of SAP MDS migration tool impact application performance?
My customer needs to migrate their regional ECC systems from Unix-based systems to Linux-based system. Some of regional systems are very big and their database sizes are over 10 Terabytes. To reduce system down time and mitigate risks of system migration cutover, the customer decided to use SAP’s Minimized Downtime Service (MDS) to migrate those…
SAP System Log Review – SAP Terminal in status Disc
Recently I was involved in reducing SAP SM21 system log. One of top messages in our SAP SM21 log is “Terminal ##### in status DISC” & “Delete session ### after error ###”. About 20 such messages were generated hourly under a particular user. I looked into this and fixed the issue. I also looked into…
SAP Performance issue from SAP server upgrading
There were performance issues in production system– longer runtime of several business transactions and Server overutilization after SAP application servers were upgraded even the upgraded system has higher capacity measured in SAPS and new servers are faster. Testing done in investigation shows that a flaw/limitation in SAP system (SAP kernel) is the culprit. The flaw/limitation…
SAP ABAP Program – reading an internal table with binary search vs without binary search
In my SAP experience, I often find that bad SAP job/program performance is due to poor program internal table handling. This is especially true when most of program/job run time is spent on CPU/ABAP side. One of common performance pitfalls is that internal table reading is not efficient. Read an internal table using binary search…