I'm a DBA and my developers are wanting to aggregate data as quickly as possible. They have run the 3 main executions within SSIS to run in parallel but rather than make the CPU hurt for a shorter period of time, it seems to flatline at around 20%.
Looking at Task Manager I can see that all cores are being used during the test runs.
It is a Windows 2016 Server running 16 CPU cores on a VM with 32GB of RAM. SQL Server 2016.
Cost Threshold for Parallelism is set to 50 and MAXDOP is set to 0 on the SQL instance.
My question is, is there a setting on the SQL Server instance or in the SSIS package that will allow me to make the CPU run at 100% and save CPU idle time?