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…
Category Archives: SAP development
Application performance control in SAP development
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…
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…
SAP Parallel Processing Introduction
Parallel processing is to use “divide and conquer” strategy to increase business process throughput and cut processing time by engaging more system resources. This post would take about SAP parallel processing and cover: What is parallel processing? What is pros and cons of parallel processing? What are driving factors to implement parallel processing? What influence…
SAP ABAP program performance tuning process
You are asked to work on a SAP ABAP program to make it run faster. It is a big program with thousands lines of ABAP source codes, so you are wondering what is starting point and the efficient process to tune the SAP program performance. This is what this post is written for. This post…
SAP project – Application Development Performance Control
In my previous post – performance control in SAP project, SAP project performance effort is divided into three important performance areas: Capacity planning, Application development performance control and Deployment/Configuration. In this post, I would talk more about application development performance control. Application development performance control is to make sure that a program or a solution…
SAP table buffering
In a SAP system, there are many layers of data buffering – IO subsystem, database system, application and program. All buffering is to make data available in memory so request for the same data can be fulfilled via memory. This helps data retrieval performance and underlying business transaction or program performance. In this post, I…
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 for SAP program/application performance tuning. Here, I would cover how to analyze SAP SQL trace to…