Description

Under high load arising from the rapid growth of the AutomationPool table, it is possible to experience the increased resource consumption on the Marketing Automation database due to a slowdown in running the AutomationPool_Add stored procedure. In this case, the AutomationPool table might get locked, and a slowdown in other operations might be observed.

This article provides a revised version of the [xdb_ma_pool].[AutomationPool_Add] stored procedure for Marketing Automation performance optimization.

Solution

To use the optimized version of the [xdb_ma_pool].[AutomationPool_Add] stored procedure:

1. Back up the Marketing Automation database.
2. Download and run the attached script against the Marketing Automation database: Sitecore.Support.336990.sql.

Once the optimization has been applied, check whether the performance has improved.