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:
Nice one Mukesh.
Will be very useful for the freshers in basis.
Regards,
Himanshu
Thank you Himanshu and Nilupal
Good contain, really helpful. Thanks Mukesh.
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.
Cheers
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
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
Its Really Helpful. thanks for sharing mukesh.
Regards,
Naresh
Hi All,
how to automate all the t-code result..???
can we use any ABAP code or any other scripting langue..?
Regards,
Ramesh