Category Archives: SAP support

sap production operation performance support

How to validate SQL performance tuning via SAP ST04 SQL cache

Sometimes, you have to tune SQL to improve SAP program performance. After SAP SQL tuning is done, is new SQL statement having better performance than original SQL statement? This post would show you an example on how to verify this via SAP ST04 SQL cache. 1 The background ST04 SQL cache showed that one SQL…

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

Would a proposed SAP code change improve program performance?

Would a proposed SAP program code change improve program performance? The approach is normally to get a before and after picture and do the comparison. But based on before the picture and planned changes, you can tell whether the planned change has potential to make a performance improvement some times. This is what I did…

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

Trouble-shoot SAP job/program termination on memory errorTrouble-shooting SAP job/program termination on memory error

It is not unusual that a SAP job/program can be terminated on memory error. In my experience, I have seen SAP job/program terminations on following memory errors: TSV_TNEW_PAGE_ALLOC_FAILED, TSV_TNEW_BLOCKS_NO_ROLL_MEMORY, TSV_TNEW_OCCURS_NO_ROLL_MEMORY and SYSTEM_NO_ROLL. This post would share my experience on how to do trouble-shooting on single sap Job/program termination due to memory errors. It would cover:…

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

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…

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

How to use /sdf/mon to review single SAP job running historyHow to use /sdf/mon to review single SAP job running history

I have several posts on my favorite SAP performance tool – /SDF/MON already. In this post, I would highlight “restricted WP list” feature provided by SAP /SDF/MON transaction. Using this feature, you can display all historical SM50 snapshots for a single SAP user, a SAP job or a process during performance issue trouble-shooting. Take a…

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

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…

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

SAP Table buffer – How is buffer state and table call statistics changed?

You can review a buffer state and call statistics data for a buffered table via SAP transaction ST10. A buffered table can have different status in different time or different status among different servers at the same time. Why is buffered table left a specific “status” and how and when it would be changed to…

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

How to run SAP transaction ST06 – Navigate through ST06 screens and understand ST06 screens

SAP transaction ST06 is an operating system monitor used to review SAP server/system capacity and current utilization of capacity as well as some capacity utilization history. Resource areas monitored by SAP ST06 are CPU, Memory, Swap, Disc and Network of a SAP system. This post would cover following topics related to SAP ST06 operating system/monitor:…

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