SAP Daily Activities

Daily Activities

1.                   Monitoring Application servers in SM51

ü     From SM51,we can Check whether all SAP servers are running or not

ü       When application server is not available, we can’t find the host name for the server.

ü       we can also get the information about number of users logged to the instances

ü       We can estimate the current activities and the resulting load on the instance

ü       And also we can monitor list of all app servers, sever info, Queue info and SNC status in SM51

ü       We can also view the status of all active/inactive instances using RZ03

2.                    Monitoring Work processes in SM50 & SM66-

ü       We can Check for Long time running work processes

ü       Check the state of work process

ü       We can cancel a process by selecting the work process and click the “process” menu, in this menu we have “Cancel” option

ü       When we cancel work process ,all transactions are terminated and dispatcher starts new work process

ü       We can also view the work processes of the instance at OS level by using DPMON p (when only one instance)

ü       DPMON P <instance profile> <SID>   (When multiple instances)

3.                   Active users over view in SM04 and AL08

ü       Display active users and their activities

ü       Checking for the users who have lost their connections

ü       We can also view the number of RFC users, number of interact users, terminal, active instances.

4.                   Check for log on load balance using SMLG(log on groups)

ü       We can check for load distribution and average response time and quality ratio ………  (in SMLG---press F5 for load distribution –now we can see log on groups, instance ,status, response time, number of users per instance ,quality of load balancing and dialog steps of each instance

ü       If any application server is goes down for any reason, user can still connect the group which will assign the best application server (SPACE –default log on group)

5.                   Checking for ABAP Dumps in ST22

ü       When user have a program error , the  dump is immediately displayed

ü       This dumps include information like “what happened”,” what can we do”,” what tables were being used at that time” and “any other program were affected”.

ü       We can see how many short dumps have been generated in the current day and previous day-----in ST22, select the day and click on the display list icon.

ü       ABAP run time errors like Syntax errors, wrong logic, exception/short text

ü       Invalid request made to DB interface when accessing table(DBIF_RSQL_INVALID_REQUEST)

ü       Application program error(MESSAGE_TYPE_X)

ü       Error occurred due to database inconsistency (start_call_sick)

ü        (DBIF_NTAB_TABLE_NOT_FOUND ,UNCAUGHT_EXCEPTIION)

ü       All these dumps are stored in SNAP table, We need to delete the old dumps, why because some old dumps may cause some more new dumps

ü       If there  are more than 20 dumps ,we should send a mail to the client

6.                   Check for Lock entries in SM12

ü       Check for Lock entries older than one day should be analyzed and corrected (lock entry menu—delete).

ü       Normally, the locks are automatically released when transactions are committed or when users are finished working on the data.

ü       But we need to aware about locks which are held unreleased for several hours---in this situation ,problem might be long running background jobs which update the data base , abnormal termination of the SAPGUI and also problems in update processing.

ü       To solve this problem ,we can  delete the lock entries or logoff the user from SM04

ü       To test whether the enqueue work process is working correctly or not  l( go to SM12 -àExtras menu-àdiagnosis

ü       All lock entries are stored in TLOCK table.

ü       Causes of malfunctions in lock management

1.       the enqueue server is not available

2.       the message server is not available

3.       faulty computer links

4.       incorrect system installation

5.       incorrect setting of system parameters

7.                   Check for any terminated updates in SM13

ü       We can check for any hanged updates, or updates pending for long or updates in PRIV mode

ü       We can check the system update records with error status or which have not yet been processed.

ü       Based on the type of error ,request the user repeat the data entry which performs the update

ü       All update requests are stored in VBLOG table

ü       we can monitor the cancelled update requests and all update requests in SM14

8.                   Check whether Production Client is open or close In SCC4

ü       Production Client should be Always in closed status unless until approved

ü       close-No changes allowed, No change repository objects and no changes with out automatic recording and no changes to repository objects and also we can set the protection level 2(no over writing, no external availability)

ü       Open-changes to repository objects, automatic recording changes  and no restrictions

9.                   Monitoring Database in DB02

ü       Check for Space of Table space used more than 90%

ü       if table space size reached 90% we need to increasing table space by adding data file using SAPDBA tool

ü       Check for Missing indexes indexes in BD02, by selecting “missing indexes “ tab we can find missing indexes like primary indexes and secondary indexes,

ü       If we find any missing indexes we can report to ABAPers they will assign those indexes to proper Tables

ü       Check for  Space critical objects (huge table/report occupy the maximum space in buffer, in this situation system may hang)

ü       If we find any space critical objects ,we should add the data file to the table space

10.               Check for the terminated back ground jobs and log time running jobs in SM37

ü       We can check the status of the job, if it is in active state for long time, we need to cancel that job(job-cancel)

ü       If it is still in active state we need to check the status in Job menu 

ü       Still it is in same state we should kill that particular work process from SAP level(SM51) or OS level (DPMON)

ü       If one particular job is cancelled more than 20 times ,a mail should be sent to the user

11.               Check for Spool requests SP01

ü       Look for spool jobs that have been “in process” for an hour.

ü       Checking for problems with spool and output request

ü       Check logs and possible causes of printing problems

ü       Check the output request attributes, the log files, and the size of the print job

ü       Check whether the device type and what the access method is for the device.

ü       Deleting old spool requests or scheduling the background job which automatically deletes them, If there are more than 50 spool errors, then they have to be deleted.

12.               Monitor the back-up logs in DB12

ü       Check whether last  back up is successful or not

ü       If it is not successful Problem might be sapbackup disk was full.

ü       We can check the redo logs which are not yet back up

ü       And check for the back up status

ü       Checking archive log directory status(oracle/SID/oraarch)

ü       Verify the log of the last backup and free space in log directory

13.                Monitoring OS logs and CPU utilization in ST06 or OS06-

ü       We can monitor the entire operating system in OS06 or ST06

ü       We can monitor OS logs and CPU utilization -detailed analysis-OS logs and CPU utilization

ü       We can monitor the CPU, memory, swaps, disks, file systems, and network (OS06-datailed analysis )  From the detailed analysis menu we can see operating system information from any of the previous 24  hours

Alert Monitoring in ST04

ü We can monitor the system alerts from RZ20-doubleclick on the corresponding monitor-in that screen click on the Open alert.

ü We can set the thresholds /alerts and our own monitors  in RZ20-extras menu-click on activate maintenance function-in that we can create threshold with colors

ü We can also monitor database alert log in ST04-Detailed analysis-error log,

ü in OS level -Oracle/SID/sap trace/back ground  directory

ü We can find the all data base errors and warnings in DB16

System log in SM21

ü we can monitor the system log in SM21

ü System Log stores all messages including problems warnings & information.

ü In this system log we mainly look for errors related to Database listed as ORA-????  Error and update terminate errors.

ü We can also monitor the local system and all remote systems logs –SM21-system log menu-select Choose option-in that we have local system, remote system options