Statistical Logs for all the R/3 System

The transaction ST07 provide information such as the numbers of users logged on into each of the SAP Application modules.

Double click on the application modules for more information breakdown.

If there are no analysis data is available for the history in ST07, it is because the program RSAMON40, which generates snapshots of the application monitor data and saves them to the database, has not started yet. If RSAMON40 runs regularly, the data may sometimes be deleted again by a reorganization program.

For releases lower than 31I, schedule the program RSAMON40 periodically (hourly) as a background job.

As of Release 31I, this report is automatically carried out by the performance collector (RSCOLL00). Check the scheduling of RSAMON40 in table TCOLL as described in note 12103.

To prevent the data from being deleted again by a reorganization program, you must still make the following entry in the SAPWLREORG  table:

CI ID =
MONIKEY = –<DATE__>+++++++
RESIDENCY = 0

To check the workload statistics for all the R/3 System, go to transaction STAD.

Why data was not showing in ST03?

Problem:
Last one month I face this problem when I am taking full system o/s backup of production server stopping all the oracle automatic serveice with SAPOSCOL &  SAPPRD_00 , STOP SAPMMC.  When backup was completed, I started all the service.  However, after some time data was not showing in ST03.  When I stop & start this sap services SAPOSCOL & SAPPRD_00, then data will start showing for some time but after 2 day same problme comes again.

All sap pjobs are running well.  What could be the problem in SAP.
Details of server:
O/S : Windows 2003
SAP : 4.7 EE
Oracle : 9i

Solution:
1. Ensure that the job COLLECTOR_FOR_PERFORMANCEMONITOR executes the report RSCOLL00 hourly. Furthermore, the report RSSTAT80 should be executed every hour. You achieve this by maintaining the table TCOLL with transaction SM31. Enter “X” in every hour for the report RSSTAT80 (column “Time of day”).

2. The report RSSTAT80 should be executed every hour. You achieve this by maintaining the table TCOLL with transaction SM31. Enter “X” in every hour for the report RSSTAT80 (column “Time of day”). You should then increase the maximum number of statistics records read in each run of RSSTAT80. You can set this value with transaction ST03, Goto -> Parameters -> Performance database. Press “Modify parameters” and enter at least 10,000 for the value “Max. number of records cumulated per call”. You must then save the settings.

3. Using transaction ST03, Goto -> Parameters -> Performance database, pushbutton “Modify parameters”, increase the value of “Max. number of records cumulated per call” to at least 10,000 and save the change. If this or a larger value is already set, please proceed as in point 2.

Finding the SAP Statistics for transactions and programs

When was a program, transaction last used?
How to know which users are using which transaction or executing which program?
Which are the most frequently used programs or transaction?

To know how many users are viewing and maintaining a particular transaction use transaction ‘ST03‘, in3.0x :-

• Performance database
• Select instance
• Select desired period
• Choose Transaction profile

To find the Frequently Used Programs or Transactions in 4.6x :-
ST03 —> Detail analysis Button –> Under Global– One recent period then select day or week or month —> Transaction profile Button

In 4.6x, you can also try the new Workload Analysis tcode ‘ST03N‘.

The SAP standard retention period is 3 months.  You can change the Standard Statistics via clicking :-
Goto -> Parameters -> Perfomance Database

To analyze the Statistics by users for transactions and programs use transaction STAT

STAT looks at the STAT file created by each SAP Instance.

It is by default 100 MB.  Every hour there is a COLLECTOR_FOR_PERFORMANCE job RSCOLL00 aggregating this data into MONI table.  It will truncate STAT file once the specified  limit is reached.

So, you can see details for however many days in this 100 MB using STAT, or ST03 to see the MONI aggregated data.

To change the 100 MB limit, ST03 -> Goto -> Parameters -> Performance Database.

Welcome to Sap Learning dot com ! This is your very first post. Click the Edit link to modify or delete it, or start a new post. If you like, use this post to tell readers why you started this blog and what you plan to do with it.

Happy blogging!