challenges with concurrency model
Challenges with concurrency model
o The partner would like more control on how many concurrency slots a query has
o The partner suggests that the concurrency slot choices are too limiting (1,2,4,8,16,32,64). They would like to choose the number of slots 1-80
o The partner would like to be able to dynamically change the number of slots - or have the system dynamically change for them
o An example of the rigidity is if the partner has 2000 DWUs - and thus 80 concurrency slots - and they have a large query running taking 64 slots, another large query would be queued, as only 16 slots are remaining. Ideally, the system would be dynamic and the 2 queries would have 40 slots.
We announced workload isolation with workload groups for preview at Ignite Nov., 2019. Workload groups allow you to specify a decimal amount of resources per request. There is no notion of concurrency slots anymore.