10-09-2013 1:20 PM
It takes about 2 seconds to save a new article in transaction MM41. This performance can be traced with transaction ST05. However, it may take several minutes, before the records are saved in table MARA, MARC, MVKE. No background jobs are visible. How can I trace the reasons for this performance?
10-10-2013 2:47 AM
Hi,
There is no separate method for tracing the performance for the given tables. The same transaction ST05 can help you to find SQL performance for these tables.
Apart from this, you can also see the status of indexes of these table in DB02 transaction to analyze. In the same transaction there is an analysis for I/O performance. Using these two tcodes, you will be able to trace the performance while creating article segments for MARC and MVKE tables. Due to issue in indexes also it may take more time to save data in these tables.
I hope this will help.
Regards,
Amit
10-11-2013 3:46 PM
Hi
Please, see Note 127905 - Performance: article maint. & data transfer art. as a checklist and related notes.
Check also if there are additional secondary indexes in tables (MARC, MBEW, MVKE and so on).
Regards
Eduardo