All posts by eric

Mass VS Individual deletion – Does it matter to SAP program performance?

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…

This content is for 1 day, 1 Month, 365 days and Life-time members only.
Log In Register

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…

This content is for 1 day, 1 Month, 365 days and Life-time members only.
Log In Register

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…

This content is for 1 day, 1 Month, 365 days and Life-time members only.
Log In Register

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…

This content is for 1 day, 1 Month, 365 days and Life-time members only.
Log In Register

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…

This content is for 1 day, 1 Month, 365 days and Life-time members only.
Log In Register

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…

This content is for 1 day, 1 Month, 365 days and Life-time members only.
Log In Register

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…

This content is for 1 day, 1 Month, 365 days and Life-time members only.
Log In Register

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…

This content is for 1 day, 1 Month, 365 days and Life-time members only.
Log In Register