SAP SYSTEM MONITORING TCODES
In this article,I am going to cover SAP SYSTEM MONITORING Tcodes , For any Basis Admin, daily sap system monitoring check is essential task.We daily do health check of our production sap system.
SAP daily system monitoring helps in two way-
Preventive Health check– This health check helps to prevent issue that may happen in near future. e.g. suppose in our daily SAP System monitoring,we catch our database size is 99 % full that means anytime in future DB size will be full and it’ll lead production outage.
Regular health check– This is regular health check which helps us for solving daily system issues. e.g We find most of the work processes in SM50 is in PRIV/Stopped mode or some user is taking all system resources/memory.This issue can be solved immediately — Killing that user session and release memory.
I have summarized below SAP SYSTEM Monitoring Tcodes ,Which are used in daily system monitoring and what we check in that Tcode.
What to Monitor ?
|SM51||Check that all application servers are up|
|AL08||Review for unknown or different user ID and terminal.|
|Take a look at the user distribution on servers|
|SM12||Lock Entry List|
|Check for locks older than one day. Analyze|
|SM13||Update Records Check all updates with status error ,Update should be active.|
|SM21||Check System Log|
|Check for: Errors|
|ST22||ABAP Dump Analysis|
|Look for an excessive number of dumps Look for dumps of an unusual nature|
|SM37||Select Background jobs|
|Review any cancelled or long running job|
|ST02||Check Swaps in status RED|
|ST06||Check CPU and Memory Utilization|
|ST03||Workload: Analysis of <sid> ,Check for any performance issue ,Bad transactions taking high response time.|
|SMQ1||Check no. of queue entries, deregister and register queues ,High no of stuck message|
|SMQ2||Check no. of queue entries, deregister and register queues ,High no of stuck message|
|SOST||Check failed Emails and Faxes and analyze|
|SM58||Check failed TRFCs and analyze|
|DB01||Analyze Exclusive Lockwaits|
|Opens Diagnostics: Locks: Blocked Transactions in DBA Cockpit.|
|DB02||Tables and Indexes Monitor|
|Opens Diagnostics: Missing Tables and Indexes in DBA Cockpit.|
|DB50||SAP DB Assistant|
|Opens Current Status: Overview in DBA Cockpit.|
|DB13C||Central DBA Planning Calendar|
|Opens Jobs: Central Calendar in DBA Cockpit.|
|DB26||DB Profile: Monitor and Configuration|
|Opens Configuration: INI Files in DBA Cockpit.|
|DB12||DBA Backup Logs|
|Opens Diagnostics: Backup Catalog in DBA Cockpit|
Don’t Miss my popular article on SAP HANA MONITORING / Differnet Monitoring Check