It is not often but can happen that a SAP transaction/process is suddenly running abnormal longer due to extracting data from database without known application changes such as volume, setting and logic. This type of performance issue is normally due to fact that database has switched to a suboptimal plan instead from a good execution…
Category Archives: SAP support
sap production operation performance support
Understanding SQL Execution plan in SAP environment
In analyzing a SAP program which spends most of run time in reading data from database, SQL execution plan is often a focus. This post would share my knowledges on SQL Execution plan in a SAP/Oracle environment. It covers following: Oracle SQL execution plan introduction, How to read an oracle SQL execution plan in SAP…
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…
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…
Frequent operations On SAP tables in SAP performance analysis
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…
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…
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…