Changing DWU for an active Synapse SQL pool

pmscorca 792 Reputation points
2024-03-07T14:44:07.3633333+00:00

Hi,

in order to scale an active Synapse SQL pool by changing the DWU value could I accomplish this task with the SQL pool up or do I need to pause it?

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,346 questions
0 comments No comments
{count} votes

Accepted answer
  1. Smaran Thoomu 9,045 Reputation points Microsoft Vendor
    2024-03-08T08:47:23.1633333+00:00

    Hi @pmscorca

    Thank you for reaching out to the community forum with your query.

    In addition to the above answer, you can change the DWU value of an active Synapse SQL pool without pausing it. Changing the DWU does not require the SQL pool to be paused or stopped. To change the DWU value you can follow the below: User's image

    However, changing the DWU may cause some disruption to running queries and may affect the performance of the SQL pool during the scaling operation. It is recommended to schedule the scaling operation during a maintenance window or during a period of low usage to minimize the impact on running queries.

    When you change the DWU for an active Synapse SQL pool, the change is applied immediately, and the SQL pool is available for use during the scaling operation. However, it may take several minutes for the new DWU value to be fully applied and for the SQL pool to reach its new performance level.

    Note that changing the DWU for an active Synapse SQL pool may also affect the cost of the SQL pool. You will be charged based on the new DWU value and the amount of time that the SQL pool is running at that DWU value.

    Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Nandan Hegde 29,886 Reputation points MVP
    2024-03-08T05:28:24.3466667+00:00

    The SQL Pool needs to in active state for it to be upgraded or downgraded

    0 comments No comments