Featured

SAP Daily Monitoring T-Codes and its description

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

Check 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.

clip_image002
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
clip_image004
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.



clip_image006
SM13

Total number of Error updates/ Updates, Please immediately intimate to user about update termination
If 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?



clip_image008
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.

 
clip_image010
clip_image012
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.
clip_image014
clip_image016
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.
clip_image018
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.
clip_image020
clip_image022
clip_image024
clip_image026
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.
clip_image028
clip_image030
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.
clip_image032
clip_image034
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
clip_image036
ST04

Performance Overview DATABASE PERFORMANCE OVERVIEW
Buffer quality
DD cache Quality
clip_image038

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.
clip_image043
 
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
clip_image048
WE02

Used to Display IDoc list.
clip_image050
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?



clip_image052


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

1 comments:

Post a Comment

Any difficult to understand and implement this then don’t hesitate to ask me via comments Your comments are always appreciated except spam.

CodeNirvana
Newer Posts Older Posts
© Copyright Full SAP BASIS
Back To Top