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
