After I posted my blog on how to run SAP ST04, SAP introduced a new feature into ST04 – DBA history which can show history of SQL stats which is only available via separate SQL script before. This is a very helpful feature in SQL performance analysis. In this post, I would talk about the…
Category Archives: SAP transaction
SAP transactions/tools used in performance analysis
How to run SAP code inspector to do static ABAP performance check?
In my post “SAP project – Application Development Performance Control”, I mentioned we can validate SAP ABAP program performance via static performance check and dynamic performance testing. Static performance check and Dynamic Performance testing complements each other to make sure that program developed has good performance. It is mentioned that we can use SAP code…
Explanation of SAP STAD Single Statistical Records/data
SAP STAD is one of my frequent used SAP transactions in performance analysis. STAD can show you where the time is spent over a list of technical components involved in a job/program execution, so it is often 1st step I would take to review performance of a program/transaction which finished recently. Following my previous post…
How to run SAP transaction RZ12 to configure RFC server group
My previous post, “SAP Parallel Process Introduction”, mentions parallel process can be implemented via SAP background process or SAP dialog process as well as factors which should be considered when we design a parallel solution. When parallel solution is implemented via SAP dialog process, SAP server group is the typical SAP solution used to control…
How to run SAP transaction ST05 to trace a SAP program execution and review trace
SAP transaction ST05 can be used to trace execution of SAP program/job to catch performance statistics related to SQL statement execution, SAP enqueue operation, SAP RFC activities, SAP Buffer access and HTTP activities. So you can analyze trace to validate performance or identify performance bottleneck. SAP ST05 allows you to enter a SQL statement and…
How to execute SQL statements directly via SQL command editor in SAP ST04
Sometimes, you might want to execute a SQL command/script directly without using ABAP program in SAP system. You cannot write an ABAP code in non-development box directly or you do not want to write a full ABAP program just for executing a SQL etc. This post would show you on how to enter SQL code…
How to run and understand SAP transaction SM12
In a SAP system, many processes/online business users can change the same business object like the same sale order. To protect data integrity, we need to allow only one process/one user to change one business object at one time. To that purpose, SAP has introduced application level lock protocol – SAP lock/Enqueue to handle concurrent…
How to run SAP transaction ST03/ST03N and navigate through SAP workload monitor screens
ST03/ST03N is a SAP transaction for workload monitor used to review SAP workload distribution both from time vertically and servers horizontally. After you review my post – SAP workload monitor overview, you get some idea on what this SAP tool is up for, now you wonder how to run SAP st03n and navigate through frequent…