SAP System Monitoring Template

[khampariamukesh]

Dear Friends,

As a SAP Basis administrator, our first responsibility is to do the monitoring every day as a first task.

Below is the format, this I have created for my Project and interested to share with you all.

Meaning of individual Column.

<<Month>> <<Year>> : Example September 2013

Analyst Name --> This is used for the person name, which is doing monitoring. Example: Mukesh Khamparia --> MK | Amitab Bachchan --> AB

W/O --> Weekly Off (No monitoring this day means of Weekend)

1/2/3 -->

If all is well then put 1 (You can put green color in corresponding column)

If there is some warning then put 2 (You can put Yellow color in corresponding column)

If there is some error then put 3 (You can put RED color in corresponding column)

Number --> Total of the failed jobs or Dumps Example : 10 or 20 or 28 whatever ..

Here 1/2/3/4/5/6 is showing dates for that month.

Production System Health Check
<<Month>> <<Year>>

Task	Transaction	Value	1	2	3	4	5	6	7	8	9	10	11
Analyst Name -------------------------------------------->>			MK	MK	MK	MK	MK	W/O	W/O	AB	AB	AB	AB
Database Health  Check
Check for Database Size  (Check Free-space of Database in %)	DB02	%
Check SQL lock	DB02/DB50	1/2/3
File system through OS level	OS level	1/2/3
Check for Red alerts (like Missing Tables and Indexes and others)	DB16	1/2/3
Check for Table-Spaces in Oracle	DB02	1/2/3
General System Health & Availability Check
Check for ”old” locks	SM12	1/2/3
Check Number of users logged in	AL08	1/2/3
Look for any failed updates (update terminates)	SM13	1/2/3
Check System Log	SM21	1/2/3
System Status	SM51
Review the SAP Buffer performance	ST02	1/2/3
Review the SAP Workload	ST03	1/2/3
Check work processes Globally	SM66	1/2/3
Total ABAP dumps	ST22	Number
Check Spool Request	SP01	Number
File system	ST06	1/2/3
Review for scheduled jobs and review job Status
Active jobs	SM37	Number
Failed/Canceled	SM37	Number
qRFC Monitor Outbound Queue
Outbound Queues	SMQ1	1/2/3
Inbound Queues	SMQ2	1/2/3
IDocs Processing
Check for failed IDocs	BD87	1/2/3
Transactional RFC
Check status of tRFCs	SM58	1/2/3
System Status
Check Client Overview	SCC4	1/2/3
Check Global System Settings	SE06	1/2/3
SAP Connect & Faxination	SCOT/SOST	1/2/3

Example of sheet: