SAP Basis - General
Check for lock entries
More info: Sm50/SM66/DB01
Update terminates, update queue, update status. Delete Errors if not required
More info:SM21/ST22
Check System Log, especially errors
Check job log: Delete old jobs from all columns if not required.
Check cancelled/long running jobs
More info: SM21/ST22/DB01/SM66/SM50
Check work processes for error, long running jobs, table usage, exclusive lock wait situation, PRIV mode
More info: SM21/DB01/ST02
Check for spool problems. Look for status other than completed.
Check critical dumps, error analysis & corrective action
More info: SM21, SE38
System performance
Review buffer statistics – check for swap, extended & heap memory
More info: ST03
Review Workload statistics; Go to Performance database -> -> today Check for today’s statistics More info: ST02
Database performance analysis. Check for expensive sqls. Analyse the cost.
More info: DB02
Operating System
Operating system monitor - check CPU utilization, Physical Memory Available, OSCOL running, OS logs
More info: AL18/RZ20
Database
Check database for free Space and max extents reached. Check growth of table & indexes. Also check for missing indexes and space critical objects
Check daily backups
executed without errors. Check log of Database & redo logs backup.
More info: DB24/ST04
Database check for error messages or warnings.
