SAP Administrator Daily Activities
SAP DAILY ACTIVITIES
A D V E R T I S E M E N T
1] Check that all the application servers are up:
sm51 SAP Servers
sm04/al08 Logon Users
2] Check that daily backup are executed without errors
db12 Backup logs: overview
3] SAP standard background jobs are running
successfully. Review for cancelled and critical jobs.
sm37 Background jobs--- Check for successful completion
of jobs. Enter * in user-id field and verify that all critical successful jobs
and review any cancelled jobs.
4] Operating system Monitoring
5] Extents monitoring
db02 Database monitoring--Check for max-extents reached
6] Check work-processes(started from sm51)
sm50 Process overview-- All work processes with a
running or waiting status.
7] Check system log
sm21 System log-- Set date and time to before the last
log review. Check for errors ,warning, security, message-bends, database
8] Review workload statistics
st03 Workload analysis of <sid>
sto2 tune summary instance
9] Look for any failed updates
sm13 update records
10] check for old locks
sm12 lock entry list
11] Check for spool problems
sp01 spool request screen-- check for spool that are in
request for over an hour.
12] Review and resolve dumps
st22 ABAP Dump analysis
13] Checking .trc file in SAP trace directory for block
corruption on daily basis.
14] Archive backup
brarchive -f force -cds -c
Insert the archive backup tape
15] Review NT system logs for problem
-> NT system log- look 4 errors or failures
-> NT security log- failed logon 2 sap servers
-> NT Application log -look 4 errors or failures
Tcodes used for Daily System Monitoring
After running daily system monitoring transaction,
what should we check for:
In st22 look for the core dumps if any and report to
the respective consultants and try to know why it happened.
In sm21 try to check for errors.
In sp01 try to see if any spool jobs have failed.
In st02 look if any swaps are happening, swaps are not
good for performance.
In st04 look for Database alert logs and Performance.
In st03 look for ratio hits.
In sm59 look for connectivety tesing if there are other
systems also connected to your SAP R/3 system
In db13 look if the jobs have run successfully.
In sm37 look for any cancelled scheduled job and take
In sm12 look for any pending locks from the previous
In sm13 look for any hanged updates, or updates pending
for long or updates in PRIV mode.