In performance analysis, we often use different sap transactions to get information related to a SAP table like table attribute, table structure, index, table size, storage quality, column statistics, table content and etc. involving SAP transactions SE11, SE16, SE14, SE13, DB02, DB05, db20, TAANA, RSANAORA, RSORAISQN and /SDF/RSORADLD_NEW. In this post, I would talk about…
All posts by eric
Values of Variant is Saved for specified screens only
There is a business need to update one of SAP program RBDAPP01 variants to enable parallel solution to cut job runtime. When we tried to “save” our changes – packet size, server group etc., a window was popped up saying “Values of variant … saved for specified screens only”. Reviewing the variant again, our changes…
ABAP programming – performance tips and tricks
When you are coding an ABAP program, you often find that the ABAP program can be coded in different ways to do the same job, you are wondering which way would give a better performance. When you are tuning the ABAP program performance, you encounter an expensive ABAP statement in SAP ST12/SE30 trace, you are wondering why…
How to find a parent job/program of a SAP update work process
You spot a long running SAP update work process via work process monitor (SAP SM50 or SM66) or /SDF/MON utilities in a SAP system, you would like to know the parent job/program which is generating the update process. So you can work with corresponding owner to tune the corresponding job/program to make updating more efficient….
SAP Lock Monitoring and lock performance issues analysis
In my previous post, I talked about how to run SAP SM12 and understand SAP SM12 functions. In this post, I would cover What is SAP lock and how is SAP lock different from database lock? SAP lock/enqueue solution architecture overview SAP lock operation health monitoring Monitoring various SAP lock fill levels Monitoring SAP lock…
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…