Checklist: Performance analysis

Customer has Performanceproblems but no connection or only a poor remote connection to SAP.


We strongly recommend every customer to install a usable remote connection to an SAP SUPPORT Center as soon as possible.
Without this connection, the solution of problems will be delayed. In critical problems it also might be necessary to have an SAP consultant analyze the system on-site.

In the case of serious perfomance problems, the following lists have to be printed:

• Once for the whole system:
  
  SM51
  
  ORACLE :
  
  ST04 -> Goto -> State -> Parameter Changes -> History of file
  
  ST04
  
  DB02 -> Missing indices
  
  DB02 -> Freespace statistics
  
  DB02 -> Goto -> Check -> Reorganisation -> Extents/Table;Index
  
  
  INFORMIX :
  
  ST04 -> Button Shared memory incl.
  
  ST04 -> Goto -> Activity -> Current statistics -> Wait statistics
  
  ST04 -> Goto -> Activity -> Database log
                                      (for the last 3 days!)
  
  ST04 -> Goto -> State -> Parameter changes
  
  DB02 -> Missing indices
  
  DB02 -> Freespace statistics
  
  DB02 -> Goto -> Check -> Reorganisation -> Extents/Table;Index
  
  How often do you run an update statistics for the database?
  
  ADABAS D :
  
  ST04
  
  ST04 -> Goto -> State -> Parameter Changes -> History of file
  
  ST04 -> Goto -> State -> Configuration
  
  ST04 -> Goto -> State -> tables/indices ->  Select table : *
                                                  ->  Missing indices
  
  How often do you run an update statistics and an update columns for the database ?
   

For DB2 database server on UNIX and Windows NT

• ST04
  
  Do lock escalations exist that caused long lock-wait times or deadlocks?
  
  If the lock list full?
  
  DB12
  
  Were the RUNSTATS runs (ALL or DBSTATC) carried out properly?
  
   
• For every SAP instance:
  
  
  SM50 -> CPU
  
  ST06
  
  ST06 -> Goto -> Current local data -> Snapshot -> Top CPU process.
  
  ST03 -> Goto -> Current local data -> Today's workload --->>>
                   --->>> Tasktype profile
                    --->>> Tasktype profile and double click on Dialog
                    --->>> Transaction profile
  ST02
  
  ST02 -> Goto -> Current local data -> Storage
  
  ST02 -> Goto -> Current local data -> Storage -> Shared memory detail
  
  SA38: RSPFPAR -> Execute

Print these lists and forward them to SAP.

This procedure can only be used in emergency situations, and is not intended to replace the Early Watch Service or Remote Support.