FAQ on SAP Performance Monitors, R/3 Syslog and System Availability
1. Question: How to delete the statistics file within R/3?
Sometimes the statistics file has to be deleted manually. Within R/3 the statistics file can be deleted via transaction ST03 or ST03N.
(Note: Starting Support Package 20 for Release 4.6C and Support Package 10 for Release 4.6D the new functions of Workload Analysis has been delivered in Tr. ST03N.
Therefore transaction ST03 is no longer supported since new functions are available in Tr. ST03N.)
In order to delete statistics file you should follow the following procedure:
Tr. ST03 --> Workload --> Reorganize --> Delete seq.stat.file
For more information about deleting thestatistics file and size of the statistics file.
2. Question: What procedure should be performed in order to delete statistics file via transaction ST03N?
Please perform the following procedure:
Tr. ST03N --> change user mode to “Expert mode” --> Collector and performance DB --> Statistics records & File --> Delete File.
Choosing the instance a dialog box appears asking whether you would like the dialog step or application statistics file to be deleted.
(Note: Please read “i” help info, which provides definitions of statistics files.)
Starting basis release 46D, once you performed above procedure, the all files “stat.DATnn” will be deleted, and not only the current file (see Note from p.3.)
3. Question: How to delete statistics file from OS level (in what directory statistics file is located)?
Some times it could be necessary that statistics file is deleted at OS level (when the statistics file is corrupted or when the file system is full).
The statistics file is located in directory #data#. You can check, for example via Tr. AL11, the directory where this file is located:
Tr. AL11 --> DIR_DATA. Here you would see the directory similar to: /usr/sap//DVEBMGSnn/data
Shutdown the instance and only after that delete the statistics file from OS level.
(Note: Starting basis release 46D, the system writes data every hour in different files; therefore in directory “data” you would find file “stat.DAT” – current file and other files with different numbers, for example “stat.DAT191”...“stat.DAT237”.)
4. Question: How can I with help of monitoring tools check online the consumption of memory in particular transaction (resource usage)?
In order to be able to monitor online the memory consumption during execution of particular transaction you should turn on the memory consumption display. This can be achieved either via menu path:
System --> Utilities --> Resource usage or typing in the command field “/$st”.
Now, during the execution of transaction, you would be able to see how much roll, heap and extended memory are in use.
5. Question: How to delete entries in table MONI?
Caution: Deleting the data records from table MONI always leads to loss of performance data.
Up to and including release 4.6 the data records from table MONI can be viewed via transaction ST03:
Tr. ST03 --> GoTo --> Performance database --> Contents of database
To select a single record for deletion, just double click on the particular entry. The entries will be deleted only when you confirm deletion by clicking on “save” button. You can also delete the group with particular ID, choosing “Del.Group” and delete performance data for particular server, choosing “Del.1 Server”.
6. Question: How to delete entries in table MONI via transaction ST03N?
In order to reach the screen “Performance: Contents of Performance DB MONI”, in Tr. ST03N perform the following:
Tr. ST03N --> change user mode to “Expert mode” --> Collector and performance DB --> Performance database --> Contents
Further procedures are similar to what is described for transaction ST03 (see p.5).
7. Question: How to check system availability?
Availability of R/3 system can be checked via availability monitor in transaction RZ20. Except this, the file “available.log” exists on Windows.
8. Question: How can I ensure the system log evaluation for longer period of time?
First you should check how many records were read and which records were excluded from the evaluation. This information is contained in line “Parameter records”. In order for this line to be displayed you must mark corresponding position via “GoTo” --> “Layout”…
If you want to assign more disk space, for local SysLog and for central SysLog the assigned disk space is controlled by parameters “rslg/max_diskspace/local” and “rslg/max_diskspace/central” respectively.
9. Question: How can I check what transactions/reports were executed for a particular time interval and what were their response time?
Answer: This information can be obtained via:
Tr.ST03 --> Performance database --> choose server --> choose day (for example “Today”) --> Time profile
Here, by clicking on particular time interval (for example 10-11), you have output reflecting information for transactions ended between 10 and 11 hours.
10. Question: How can I reach "Time profile" (p.9) via transaction ST03N?
In transaction ST03N the “Time profile” is available in the left line under “Analysis View”. If you need information for previous months, you need to change user mode to “Expert mode”. Here you can choose required instance and time interval.