system configuration-
user count- 1200 Data warehouse Units- 1000dWU current maximum concurrency- 128 resource class used most- staticrc20(90%) , staticrc30(8%), smallrc(2%) DB size- 500 TB
Problem statement- We are integrating data from multiple sources and merging into our one dedicated SQL pool. All users are dependent on this data and we can not push data into multiple pools because of its volume and time limit. So we are entirely dependent on single SQL pool.
As users are increasing drastically higher SLO also not helping to increase in concurrency and not a long term solution.
is there any way that we can move forward with any approach as part of capacity planning ?
