Performance: ETL packages blocking on each other when using parallelism of 2 or more

When the ETL is initially deployed you can specify the 'ETL Max Parallelism' from the 'Edit advanced settings' screen on the Blackbaud Data Warehouse Deployment Wizard. The Max ETL Parallelism determines the maximum number of SSIS packages to run in parallel. When using a Max ETL Parallelism of 2 or more, some SSIS packages can block another SSIS package from running.
We are currently evaluating this issue and will update this article when we have more information.

Steps to Duplicate

1. Navigate to Administration and select Data warehouses.
2. Select 'Blackbaud Data Warehouse'.
3. Under 'Refresh data', select 'Start ETL refresh'.
4. Check SQL Snaps and see that there may be a package that is blocking another package from running.

Environment

 Blackbaud CRM
 4.0

Was this article helpful?