Azure Synapse Analytics Instance Scaling - Pool separation

Vladimir Nekic 22 Reputation points
2020-06-04T13:51:21.713+00:00

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
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,369 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ronen Ariely 15,096 Reputation points
    2020-06-05T10:48:02.03+00:00

    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).