Search code examples
azure-synapse

How to increase DWUs on Azure Synapse Dedicated SQL Pool

I inherited an Azure Dedicated SQL Pool at my current firm. The DWU was set at 100, is there a way to increase the DWU's? It would be appear I would have to create a new Dedicated SQL Pool to increaase the DWU's

enter image description here

Also, is there a guide showing what DWU's are best for a particular environments? For example, Microsoft recommend a minimum of 1100 DWUs for production, but I'm not sure what production environment that is based on?

Solution
    • In Azure portal, Click the dedicated SQL resource where you need to increase DWUs.

    enter image description here

    • Then click Scale

    enter image description here

    • Then, Increase the DWU based on the requirement.

    enter image description here

    You can also use t-sql command, powershell to change DWUs.

    Reference: Microsoft document on Changing DWUs