Increase Concurrency limit as a tweakable system parameter
Increase the concurrency limit from 32 to unlimited and keep it tweakable , so the customers can vary it according to their needs
Concurrency was increased to 128. Unlimited concurrency requires further analysis.
Garrett Baltzer commented
I agree. This is the biggest pain point for us when using the SQL DW.