There is a built-in recurring task in the CentralizedIndexingActivityQueue that deletes the executed old IndexingActivities every 23 minutes. The "old" means 23 minutes now:
DELETE FROM IndexingActivities WHERE RunningState = 'Done' AND (LockTime < DATEADD(MINUTE, -23, GETUTCDATE()) OR LockTime IS NULL)
23 minutes is not enough in many cases so make this value and deletion interval configurable.
Desired section, keys and defaults:
There is a built-in recurring task in the CentralizedIndexingActivityQueue that deletes the executed old IndexingActivities every 23 minutes. The "old" means 23 minutes now:
23 minutes is not enough in many cases so make this value and deletion interval configurable. Desired section, keys and defaults: