SAP Note 15374 - Checklist: Performance analysis

Symptom:

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

Cause and prerequisites

Many possible reasons.

Solution

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.