Azure Synpase DWU

Rakesh Singh 16 Reputation points
2022-02-07T00:38:40.723+00:00

Hi - Is there a way to find out vcores and ram corresponding to say 100 DWU's?

In documentation its mentioned that 100 DWU will correspond to 1 compute node but i'd like to know the ram and vcores if possible?

Thanks

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,395 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee
    2022-02-08T14:30:48.717+00:00

    Hi @Rakesh Singh ,

    Thank you for posting query in Microsoft Q&A Platform.

    A dedicated SQL pool (formerly SQL DW) represents a collection of analytic resources that are being provisioned. Analytic resources are defined as a combination of CPU, memory, and IO.

    These three resources are bundled into units of compute scale called Data Warehouse Units (DWUs). A DWU represents an abstract, normalized measure of compute resources and performance.

    Yes as you rightly pointed 100DWUs is equal to 1 compute node. There will be 60 distributions per compute node. Click here to know more about same.

    172253-image.png

    Regarding exact RAM and vcores details I am checking with internal team if any insights I can get. I will update thread once I get some updates.

    Hope I this helps.

    Please consider hitting Accept Answer. Accepted answers helps community as well.

    1 person found this answer helpful.