Daily BW System checklist

This list of transactions is designed to guide a Basis Admin team member through the process of keeping tabs on major systems issues and root cause issues and trends for each system in the landscape.

This will only identify and help triage issues to Helpdesk, Infrastructure, OS team or DBA team, Basis or functional developers or whomever…but guarantees that each system in a landscape gets a regular, weekly look. The goal is to eliminate root causes of repeating issues.

Step One
Identify what is going on right now
Why? This info may skew other readings
SM51 – SM50 (or SM66 and SMGW) – what’s running and active now
SMICM – what’s going on in the web server…and max/peak usage
AL08 – who’s on and inactive…what are they doing?

Step Two
Analyze what happened overnight
Why? ID any major new issues or daily trends for loads
ST22 – short dumps indicate major issues
SM21 (change time filter to include since you last looked) for each app server – shift in SM51
SM37 – active or cancelled jobs
RSMO – overview of process chains/InfoPackages (also RSA1-monitoring-monitor)
RSPC – log view of trouble chains
STMS – import history

Step Three
Check weekly trends (once per week per system is ok)
ST02 – look at buffers – red? Quality lower than 90%? >20,000 swaps?
ST04 – database buffer quality – in detail analysis, lockwait, latchwait, db message log
ST06 – CPU usage, now and detail-CPU snap and CPU previous hrs, OS Log
DB02 – disk space and weekly growth...and that disk storage availability is ahead of needs

Step Four
Major troubleshooting transactions if deeper analysis required
SE03 – STMS – SE09/SE10 TMS info – observe import history patterns
SLG1 – Application Logs
RSD1 – Repair InfoObjects
RSRV – Analysis and repair of BW Objects – Master data to Transactional Data ratio
ST03N – Query and Load performance analysis – BW Expert mode
RSRCACHE – Web query cache (parameters RSCUSTV14)
RSRT/RSRT2 – query analysis – which area is that problem happening in?
AL11 /work process/RFC logs
BW Stats Queries (0TCT) – examine for trends out of the ordinary/expected
WE20/WE21/SM59 – system connections or SE16 tables related to these
SE38 Reports:
SAP_INFOCUBE_INDEXES_REPAIR
RSPARAM
RSCR_CHECK_INSTALLATION_PARAMS (Crystal Enterprise)
RSPOR_SETUP (portal configuration)
RSAR_RSISOSMAP_REPAIR
BW_IGS_ADMIN or BW_IGS_CHART_TEST (IGS)
SRMO or RSODADMIN (TREX)SPAD – printing issues