Skip to Content

SAP System Monitoring Template

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:

11.PNG

9 Comments
You must be Logged on to comment or reply to a post.