1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

Performance Issue - During Month End Activities

Tuesday, 25 July 2017 04:41

In one of our production system, we encountered a massive performance issue primarily due to database request time. In MSSQL, it is written in every Microsoft/SAP articles that the statistics will be updated automatically  and there is not a need for manual execution.   But in case of an ECC system, during the month end activities, we could see potential performance issues especially with the tables related to financial data, in most of the cases, we will run the update statistics manually which in turn will increase the performance.

Read more...

Performance issue - Sequential Reads on Table ATP_RESB

Tuesday, 25 July 2017 04:41

Sometimes after a monthly maintenance, when creating PO’s and maintaining purchase orders, we had performance issues in the R/3 system. Further we could see too many work processes running for a long time and they were doing fetch operation on table ATP_RESB.

Read more...

Do you know what is meant by Clustered Index Seek and Index Seek in Query Execution Plan?

Tuesday, 25 July 2017 04:41

Do you know what is meant by Clustered Index Seek and Index Seek in Query Execution Plan?

 

 

Read more...

Understanding STAD - Part 2

Tuesday, 25 July 2017 04:41

The input parameters in STAD transaction are discussed in detail in this article.

Read more...

Understanding STAD - Part 1

Tuesday, 25 July 2017 04:41

Introduction

STAD is the transaction used to understand the performance of a given transaction/program in SAP, it helps you to understand every step of the transaction in detail.  When you are asked to perform an analysis of a particular transaction, this is the first and foremost transaction must be used to decide whether performance

Read more...

Performance Tuning