Displaying and Changing the Scheduling of Performance Collectors 

Use

The workload monitor reads the workload statistics from the workload collector database. Various collectors must run at regular time intervals so that this database always contains current data.

This is done using the background job SAP_COLLECTOR_FOR_PERFMONITOR. This job runs once an hour on an instance of the system. The job executes report RSCOLL00, which starts the various collectors in accordance with the entries in table TCOLL.

Note that the collectors in table TCOLL not only form the basis of the data for workload monitor, but are also of importance for other transaction (ST02, ST04, ST06, ST10). This means that the collectors supply not only the workload collector database, but also the monitoring database MONI with values.

By changing the entries in TCOLL, you can determine which collectors are to run and how often. Usually, you do not need to change these settings. There are two conceivable situations in which you would need to change the entries in TCOLL.

·        The workload collector database or the monitoring database MONI is too large due to the quantity of collected data.

·        The collectors themselves are causing too much workload.

For information about the various collectors, for which the scheduling is determined using the entries in table TCOLL, see SAP Notes 12103 and 127642. Both SAP Notes are regularly updated.

Procedure

...

       1.      Start the Workload Monitor by calling transaction ST03.

       2.      Ensure that you are in the Expert user modesapurl_link_0003_0001_0002.

       3.      In the navigation bar, choose the entry  Collector & Performance DB →  Performance Monitor Collector →  Execution Times. The TCOLL List screen appears.

This shows an execution timetable for the various collectors. Each row specifies for a collector on which week days and at which hours of the day the relevant report is executed. For an execution, both conditions (week day and hour) must be fulfilled.

Note that the columns for the week day all have the same column heading Day or Weekday. The first column of this type stands for Monday, and the columns then run in the normal sequence.

The Type column the instances on which the report is to run.

Type	Meaning
S	The report is executed exactly once in the system (in the local background work process).
A	The report is executed on every instance.
H	The report is executed once per host.
%	The report is executed on the instance specified in the Application Server field.

       4.      If you want to change execution times, choose the Table Maintenance button. The Performance Collector: TCOLL maintenancescreen appears.

       5.      Each row contains the execution times of a report.

-         Use seven characters in the column Days:M-W-F-S to specify the week days on which the report is to be executed. Enter a character for every weekday, starting with Monday: X (the report is to be executed on the corresponding weekday) or space (the report is not to be executed on the corresponding weekday).

-         Proceed in the same way in the Hours: 0-2-4-6-8-0-2-4-6-8-0-2- column, in which 24 individual characters stand for the hours of a day from midnight to 11 p.m.

-         Specify how often the report is to be executed per pass in the column R.

-         Specify where the report is to be executed in the column S (see the Type column).

-         You can explicitly specify an instance in which the report is to be executed in the Alternative System column.

 Workload Monitor start page