Solution : https://service.sap.com/sap/support/notes/15374 (SAP Service marketplace login required)
Summary :
The customer is experiencing performance issues but has no remote connection or a poor connection to SAP. There could be multiple causes for these issues. To resolve them, it is essential to establish a reliable remote connection to the SAP Support Center. For significant performance problems, specific system information is required: SM51, ST04 (Oracle and INFORMIX specific lists), DB02 for missing indices and freespace statistics, and other details for ADABAS D and DB2 databases. Additionally, SM50, ST06, ST03, ST02, and RSPFPAR lists for each SAP instance should be collected. These lists must be printed and sent to SAP for further analysis. This approach is only for emergencies and does not replace standard support services.
Key words :
dialog --->>> transaction profile st02 st02 -> goto -> current local data -> storage st02 -> goto -> current local data -> storage -> shared memory detail sa38, file st04 db02 -> missing indices db02 -> freespace statistics db02 -> goto -> check -> reorganisation -> extents/table, sm50 -> cpu st06 st06 -> goto -> current local data -> snapshot -> top cpu process, db02 -> missing indices db02 -> freespace statistics db02 -> goto -> check -> reorganisation -> extents/table, file st04 -> goto -> state -> configuration st04 -> goto -> state -> tables/indices -> select table, st04 -> goto -> activity -> current statistics -> wait statistics st04 -> goto -> activity -> database log, st03 -> goto -> current local data -> today', st04 -> button shared memory incl, st04 st04 -> goto -> state -> parameter, workload --->>> --->>> tasktype profile --->>> tasktype profile
Related Notes :
| 489690 | CC INFO: Copying large production clients |
| 311644 | IS-Oil performance: Collective note |
| 138573 | i.s.h.med Performance Problems |
| 68896 | R3trans: Performance problems and cluster |
| 67205 | CC-INFO: Copying large and productive clients |
| 31511 | Program runs very long: Performance analysis |