SAP_COLLECTOR_FOR_PERFMONITOR Behaviour

[Former Member]

Hello,

The Basis job SAP_COLLECTOR_FOR_PERFMONITOR

runs every hour in our system. 23 times a day it runs in just a few minutes. However, every morning at the 7:30 run, it will execute for 2-3 hours.

Is there some event/activity within the system that would trigger/cause the collector job to run for hours only once a day? The program we see in SM50 that is executing for the extended amount of time is RSORAT6M.

Thanks

chris

[brendan_ocallaghan]

Hello Chris,

You should check the following SAP note if RSORAT6M is taking that long to run:

1. 713211 - Poor performance of database collector

I believe report RSORAT6M is is executed by RSDB_TDB, which is defined in your TCOLL table. You should ensure that your TCOLL is setup correctly as shown in the following SAP notes, which depend on your release version:

12103 - Contents of the TCOLL table

970449 - Contents of TCOLL table in SAP_BASIS 640

966309 - Contents of table TCOLL in SAP_BASIS 700

966631 - Contents of TCOLL table in SAP_BASIS 710

Regards,

Brendan

[Former Member]

Hi Chris,

There is nothing wrong with the job behaviour. SAP_COLLECTOR_FOR_PERFMONITOR is using TCOLL table definition to identify what reports should be executed at particular times. That means that this job will not execute the same reports all the time (e.g. each hour) it's scheduled (unless it's defined in TCOLL matrix).

To see/change the content of TCOLL table you need to run ST03 (ST03N) transaction in the Expert mode and open Collector & Performance DB => Performance Monitor Collector => Execution Times. Check out the following link for more info: http://help.sap.com/saphelp_erp2005/helpdata/en/84/9e0e422dfcdc2ce10000000a1550b0/frameset.htm

Regards,

Mike