question

VladimirNekic-7631 avatar image
VladimirNekic-7631 asked ·

Azure Synapse Analytics Instance Scaling - Pool separation

When scaling OUT a Synapse Analytics Instance, will this allow multiple pools to sit on-top of a single data warehouse and be online at the same time?

Example:
So that one is always running at say 200 DWU for simple queries and another that we can scale up and down as needed for loading data and in doing this, will these data pools stay out of each others way?

azure-synapse-analytics
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

pituach avatar image
pituach answered ·

Good day,

Note: I split the answer and skip some important points since the forum does not allow me to publish it in one message (Know annoying issue).

When scaling OUT a Synapse Analytics Instance, will this allow multiple pools to sit on-top of a single data warehouse

I have a feeling that there is small confusion regarding the names of the entities.

"Azure Synapse Analytics workspace" is basically the equivalent to the "Azure Logical SQL Server". I means that these provide the rapper (a logical instance) to manage the attached entities. Azure Synapse Analytics workspace can include Azure Synapse Pools and Azure Spark Pools, just as the Azure Logical SQL Server can include Azure SQL Databases and Azure Synapse Pool (Notice that Synapse Pools can be attached to Azure SQL Server as well as to Azure Synapse Analytics workspace).


5 comments Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

For example, check the images bellow

If you use the portal and navigate to specific "Azure Logical SQL Server instance" then you will see all the databases attached to this logical instance, and you can manage the databases.

If you use the portal and navigate to specific "Azure Synapse Analytics workspace" then you will see all the databases attached to this logical workspace, and you can manage the Synapse Pools.

0 Votes 0 · ·

The Synapse Pool is a Data warehouse database

0 Votes 0 · ·

(which is why the sentence multiple pools to sit on-top of a single data warehouse make no sense).

0 Votes 0 · ·

9128-workspace.png

9241-sql-server.png

As you can see in the image Synapse Pools can attached to both.


0 Votes 0 · ·
workspace.png (64.6 KiB)
sql-server.png (70.0 KiB)
Show more comments