Static resource classes are now supported in Azure SQL Data Warehouse
Posted on Thursday, November 16, 2017
Azure SQL Data Warehouse now supports static resource classes (staticrc10 through staticrc80) in addition to the existing dynamic resource classes (smallrc, mediumrc, largerc, xlargerc).
Each resource class represents how much memory is granted to each of the 60 distributions within a DWU. Static resource classes allocate the same amount of memory regardless of the DWU that you scale to. For dynamic resource classes, a variable amount of memory is allocated based on the current DWU.
Static resource classes enable the following scenarios for you:
- Increase concurrency as you scale up, because static resource classes grant a fixed amount of memory.
- Enable granularity over existing dynamic resource classes, because static resource classes range from staticrc10 through staticrc80.
You can find more details, including our guidance in choosing resource classes, on our documentation page.