Scaling an Azure Synapse SQL pool instance using PowerShell
An Azure Synapse SQL pool can be scaled up or down as per the usage or the workload requirement. For example, consider a scenario where we are at performance level DW100c. A new workload requires a higher performance level. Therefore, to support the new workload, we can scale up to a higher performance level, say, DW400c, and scale down to DW100c when the workload finishes.
In this recipe, we'll learn how to scale up or scale down an Azure Synapse SQL pool using PowerShell.
Getting ready
Before you start, log in to Azure from PowerShell. To do this, execute the following command and follow the instructions to log in to Azure:
Connect-AzAccount
You need a Synapse SQL pool to perform the steps in the recipe. If you don't have an existing Synapse SQL pool, you can create one using the steps from the Provisioning and connecting to an Azure Synapse SQL pool using PowerShell recipe.
