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.

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.

Procedure

1. Start the Workload Monitor by calling transaction ST03.
2. Ensure that you are in the Experts User Mode.
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.

   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 maintenance screen 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.