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

To report this post you need to login first.

9 Comments

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

  1. Pradeep Kumar

    Hi Mukesh,

    Thanks a lot!!

    I would like to add some more T-codes.

    1.STMS_IMPORT – aborted Transaports Requests with RC=8 or more, long running transports import

    2.SP12- Spool inconsistencies

    3.SLG2-Expired applications log deletion

    4.SMICM-HTTP,HTTPS service status

    5.SLDCHECK – dual stack system

    6.SM59 – important  RFC connections test such as OSS RFC

    7.STMS – TMS alert monitor and consistency check

    8.DB12 – yesterday’s backup status

    9.DB13- scheduled Database jobs status such as clean up logs,DB check etc

    10.SMLG – logon group load distribution

    Thanks for nice template.

    Cheers,

    Pradeep.

    (0) 
    1. Mika Karvonen

      Hi Mukesh,

      It depends what are the responsibility areas for Basis team. If IDoc monitoring using BD87 is required, then I think also SXMB_ADM for SOAP/Proxy errors should be also in list?

      Br, Mika

      (0) 
      1. Mukesh Khamparia Post author

        Hi Mika,

        You are right. Here I have tried to help with Template and people can add their t-codes based on business requirement.

        Yeah, we can add these t-codes in monitoring list.

        Mukesh Khamparia

        (0) 

Leave a Reply