SAP Daily Monitoring T-Codes and its description

By | 02/09/2013

Here I have listed down few Tcodes which is usually monitored in almost every SAP Landscape
Daily Monitoring T-Codes

SM51:
Check a number of instances with status will display the SAP servers and you can select the particular server and check the work process running on that application server on clicking on any work process it will take you to that application server.

SAP Daily Monitoring T-Codes and its description
AL08:
Check number of active users. If it exceeds the threshold limit, take action
Shows the list of all the users who are logged on to the system globally or for all the instances in the system which are active
SAP Daily Monitoring T-Codes and its description
SM12:
List of number of lock entries. Long pending lock entry by user > 2hrs except for system jobs.In a system whenever a user performs any update on any table for that period of time a lock on that particular field of that table is created so that no other user can update that table as user one is doing update on that table.And suppose during the update user session get terminated due to some error then this lock entry remains on that field. From this Screen we can check those type of locks.

  1. Run T-Code SM12  “Select Lock Entry” window will come
  2. Change the User name to “*” because we have to report for all users and click on list button from top or press F8.

SAP Daily Monitoring T-Codes and its description
SM13:
Total number of Error updates/ Updates, Please immediately intimate to user about update termination
If the number of updates exceeds the limit, take action
Check:

  • Is the update active? If not, was it deactivated by the system or by a user?
  • Have any updates been canceled (with status Error)? (Make sure that you enter “*” in the user field.)
  • Is there a long queue of pending updates older than 10 minutes?

SAP Daily Monitoring T-Codes and its description
SM21:
Check System log. Specify problems/action taken
Go to tcode SM21. In the menu, follow the following
Path:

System Log —> Choose—> All remote system logs.

SAP Daily Monitoring T-Codes and its description
SAP Daily Monitoring T-Codes and its description

DB02OLD:
Name of the tablespaces with <5 GB and the action taken. Check for tablespace PSAPBTABD & PSAPBTABI
When we go for DB02OLD for tablespace history for the table PSAP<SID>.which is displaying unconverted format in used space in delta column the unconverted format is displaying after the number.
SAP Daily Monitoring T-Codes and its description
SAP Daily Monitoring T-Codes and its description
DB01:
Number of deadlock along with Table Name if any deadlock for more that 600 sec then remove the deadlock
DB01 shows Exclusive HOLDs and Exclusive WAITs situations.
HOLD & WAIT situation occur when a resource is held by a user/process exclusively which is called a HOLD, and another process is trying to access it and goes to a WAIT situation.
We need to take care when locks are holding for a long time, and when it leads to a deadlock situation.
SAP Daily Monitoring T-Codes and its description
SM37:
Total numbers of active jobs & check any ready status job, if anything found take action and monitor the delay jobs and take action
Once you create a job via SM36 or via some programs, the jobs will be coming under Scheduled job.
If you submit a job via program, the job will be released automatically. but if you schedule a job then SM36 , it’ll be under scheduled and u have to release that job to run–you can see release button
Once you release that job , it’ll go to active state and then finished or if any issues come , it’ll be under cancelled..
Scheduled- Released- Ready- Active- Finished- Canceled
these are all for users to see the job, I mean the Job status. This whole cycle will be run automatically. You need to release the Job that’s it.
SAP Daily Monitoring T-Codes and its description
SAP Daily Monitoring T-Codes and its description
SAP Daily Monitoring T-Codes and its description
SAP Daily Monitoring T-Codes and its description
SPAD:
Total No. of Spool request > Threshold –take action spool errors if any check reasons check for spool waiting for printing
The SAP spool system manages its own output devices. This includes mostly printers, but also fax and archiving devices. In order for you to use output devices defined in your operating system from the SAP System, you must define these devices in the SAP spool system.
SAP Daily Monitoring T-Codes and its description
SAP Daily Monitoring T-Codes and its description
SMLG:
List the name of the Server having Response time> 2 Sec
Go to transaction SMLG, and than go to -> load distribution.
There you will see a response time of the individual application
servers.
SAP Daily Monitoring T-Codes and its description
SAP Daily Monitoring T-Codes and its description
SM66:
Global Work Process Overview
This transaction code gives you the detail of the work process which are not local or just say its for the whole system or the active instances in the system.
Check the CPICIPJSR and CPICIPPUN user, if any user got stuck more then 500 ms check the jobs and take necessary action
Check for NRIV table.
Check that processes should not stuck on particular table, if yes; mention Table Name and the number of processes
Check Number of queries running > 1500 sec
SAP Daily Monitoring T-Codes and its description
ST04:
Performance Overview DATABASE PERFORMANCE OVERVIEW
Buffer quality
DD cache Quality
SAP Daily Monitoring T-Codes and its description
ST06:
Average Server Workload
To exclude performance problems being caused by other components outside the database, you should also use transaction ST06 for analysis. With this transaction you can see whether performance problems are caused by too much strain on the hardware (CPU, RAM).
In the menu Detail analysis menu -> Daily averages -last 30 days -> Display within server you see the average workload of the server.
SAP Daily Monitoring T-Codes and its description

Check:

  • CPU utilization
  • Memory utilization
  • Swap space utilization

ST22:
We can use the tools of the ABAP dump analysis (ST22) to list the ABAP runtime errors that have occurred in an ABAP system as well as the relevant short dumps.
Call ABAP Dump Analysis, either by calling transaction ST22 or using the Easy Access favorites.
Choose the System menu, and then the option
User Profile -> Own Data
SAP Daily Monitoring T-Codes and its description
WE02:
Used to Display IDoc list.
SAP Daily Monitoring T-Codes and its description
ST03N:
Statical Files Deletion (ALTERNATE DAYS)
The following are important analysis views in transaction ST03N:

  • System load overview: general response time distribution across different task types
  • Time profile: How does the response time react over the day? Are there peak times with bad response times?
  • Transaction profile: Can you observe response time problems in general or only in certain transactions?

SAP Daily Monitoring T-Codes and its description

  • Switch to expert mode
  • Go to collector and performance to delete files

Click on the links below to read the following blog posts:

One thought on “SAP Daily Monitoring T-Codes and its description

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.