SC is driven from the EC audit events, generating process instance and work item statistics that can be used to run reports against. Background threads in the BPM node generate these statistics
Stats Collector data is processed as follows - - When an event is persisted in EC_EVENT_INT, a request to process statistics for this event is queued into EC_EVENT_TRIGGER - The SC background thread picks up this request and processes them to the target SC tables - EC_PE_ACTIVITY, EC_USER_ACTIVITY, EC_CASE_STATUS, EC_PE_STATUS & EC_WI_STATUS.
Note: If data from the above SC tables are not used, then it is safe to disable SC.
Issue/Introduction
This article outlines the steps needed to disable Statistics Collector (SC).
Environment
ALL
Resolution
Following steps are required to disable SC -
1. Disable the SC thread -
In sc.properties, add or modify the property -
eventProcessorSuspend=true
2. Disable the enqueue of requests in EC_EVENT_TRIGGER -
In ec-event-rules.xml -
===============
In default_stagingareatrigger, comment out all messageId's except for BX_TEMPLATE_DEPLOYED
<channel name="default_stagingareatrigger" target="StagingAreaTrigger">
<rules>
<rule name="TriggerMessages" ruleOrder="800">
<filter>
<messageIds>
.
.
<messageId>BX_TEMPLATE_DEPLOYED</messageId>
===============