Azure Synpase DWU

Rakesh Singh 21

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

ShaikMaheer-MSFT 38,441 Reputation points Microsoft Employee

2022-02-17T09:30:40.28+00:00

Hi @Rakesh Singh ,

Following to see if the below answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.
ShaikMaheer-MSFT 38,441 Reputation points Microsoft Employee

2022-03-04T06:42:09.8+00:00

Hi @Rakesh Singh - just checking if below answer helps. If yes please mark it as Accepted Answer. Accepted answers helps community as well. Thank you.

1 answer

ShaikMaheer-MSFT 38,441 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.

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.
Please sign in to rate this answer.

1 person found this answer helpful.
ShaikMaheer-MSFT 38,441 Reputation points Microsoft Employee

2022-02-11T15:43:32.477+00:00

Hi @Rakesh Singh ,

Got response from internal team. we do not publish vCore details because that would limit us in what the underlying hardware is for each of our nodes. Hence getting vCore details will not be possible.

But if you are looking for any performance optimization, then there are some best practices documented. Click here to know more about same.

----------

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

ShaikMaheer-MSFT 38,441 Reputation points Microsoft Employee

2022-02-15T16:36:40.627+00:00

Hi @Rakesh Singh ,

Just checking in to see if the below answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure Synpase DWU

1 answer

Your answer