CODEWITHSUNDEEP
azureazure-synapse
Vibha
Vibha

Reputation: 1109

Why does Azure Synapse limit the Storage Node size to 60?

I see that Synapse provisioned SQL pool (SQL DW) design keeps the data distribution limited to 60 nodes. Am I understanding that limitation correctly?

If so, how and why did Microsoft arrive with this specific number? Why 60 and not (say) 50 or 70? I am asking for an explanation of the design decision that led to the product having a configuration limit.

Upvotes: 1

Views: 600

Answers (1)

Ron Dunn
Ron Dunn

Reputation: 3078

It was a number that had many factors :)

60 is the number of SQL distributions, which are supported on 1 to 60 nodes.

We can use 1, 2, 3, 4, 5, 6, 10, 12, 15, 20, 30 or 60 (did I get all of them?) possible nodes per scale configuration.

Upvotes: 1

Related Questions