Category Archives: SAP support

sap production operation performance support

How to deal with SAP program performance issue due to suboptimal execution plan

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…

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

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…

This content is for 1 day, 31 days, 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, 31 days, 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 Free, 1 day, 31 days, 365 days and Life-time members only.
Log In Register

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…

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

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…

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

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….

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

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…

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