Avatar

Community Advisor

Hi,

Session-wise:

Operator sessions are tracked in xtk:sessionInfo, which doesn't touch XtkNewId.

DB sessions, sprocs, triggers, internal maintenance scripts, etc also don't touch XtkNewId.

Workflow-wise:

Workflow audit log uses XtkNewId in older builds. To remediate:

  • Reduce the amount of logging in the workflow
  • Reduce the frequency of execution of the workflow
  • Use a dedicated sequence for the table(s) being inserted into
  • Use a dedicated sequence for xtk:workflowLog
  • Avoid storing raw activity data in Adobe Campaign's db. If external delivery logs are being stored in custom tables, consider using the ootb ones instead.

Out of curiosity, what is 'cache value of xtknewid' and where is it set to 30?

Thanks,

-Jon