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…
Category Archives: Case study
share how to use one or several performance tools to trouble-shooting a real performance issue
SAP SBWP workflow item deletion performance issue
The performance issue is that our SAP users were taking minutes ( some time even more than half hour) instead of seconds to delete a workflow item via SAP transaction SBWP. What was making SAP SBWP to take that long to delete a SAP workflow item and what we did to fix this performance issue?…
SAP program performance tuning – Suboptimal SQL execution plan part 2 of 2
This continues my previous post on Oracle SQL execution plan issue. My previous analyzed a SAP ST12 trace and found program spent most of time on a SQL statement which is using hash join method to retrieve data from two tables. And one step in the hash join is to build hash table using 1…
SAP program performance tuning – Suboptimal SQL execution plan part 1 of 2
In this post, I would share one performance tuning experience related to long running job due to suboptimal SQL execution plan. My teammate had done a SAP ST12 trace and trace showed that the job spent a lot of time on one particular SQL. I was consulted recently on what concern I would see with…
Why is runtime so different for the SAP daily job with similar volume?
In this post, I would go through how I did troubleshooting a SAP job performance issue and identified database server capacity as a root cause. The job performance was improved by workload adjustment and significantly improved with added database server capacity together a code change which change synchronous updating to asynchronous updating. The overall troubleshooting…
SAP MRP Job Performance and Table Fragmentation
SAP MRP job is a critical business job. Delay completion of MRP job would delay/impact many business operations in ECC system. MRP job runtime can be impacted by many factors. In this blog, I would share one case where MRP job runtime was suddenly more than double due to SAP table fragmentation. After selected tables…
SAP ECC-BW interface: IDOCs/TRFCs were stuck in source systemSAP ECC-BW interface: IDOCs/TRFCs were stuck in ECC system
There was a performance issue of sending data to SAP BW from ECC system. When I started to work on this, it was not sure where the issue was (BW, ECC and etc.) and why the issue had been happening. In this post, I would share how I have done troubleshooting on SAP ECC-BW data…
SAP background job is running long due to inefficient index
In this post, I would show how I did troubleshooting on a long running job. My investigation found that runtime of the job was mostly spent on reading a SAP table VLKPA. The SQL access path chosen by database to read the table is correct based on then-existing VLKPA index. But the index used is…