Static resource classes are now supported in Azure SQL Data Warehouse

16 November 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.

Free account

Get $200 in Azure credit and 12 months of popular services – free

Start for free

Visual Studio

Subscribers get up to $1800 per year of Azure services

Activate now

Start-ups

Join the BizSpark programme and get free Azure services

Learn more