Is it recommended to adjust the 'MaxDeletedHosts' shepherd_config value to reduce upgrade times?

Products

• Carbon Black App Control

Issue/Introduction

Is it recommended to adjust the ''MaxDeletedHosts' shepherd_config value if the migrate.sql step 294 of the AppC Server upgrade takes longer than expected to complete?

Environment

• Carbon Black Application Control Server: 8.11.2 and higher
• Microsoft Windows: Supported Versions

Cause

Step 294 of the 'migrate.sql' AppC Server upgrade script modifies the 'host_metadata' table in the DAS database and upgrade time can be dramatically increased depending on the size of this table.

Resolution

No, it should not be necessary to adjust the 'MaxDeletedHosts' shepherd_config value to reduce the AppC Server upgrade times.

Additional Information

• Changing the 'MaxDeletedHosts' shepherd_config might have a side effect where the DAS database could still have some inventory/events data linked to deleted hosts that might not display computer/host data in the AppC console going forward (that is if the MaxDeletedHosts value is too aggressive and the linked data was not already pruned).
• This should not happen because nightly pruning should delete inventory linked to freshly deleted/disabled machines.