Saturday 3 September 2011

System Monitoring Daily Tasks

 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.

No comments:

Post a Comment