Quickstart: Scale compute for Synapse SQL pool with the Azure portal

You can scale compute for Synapse SQL pool (data warehouse) using the Azure portal. Scale out compute for better performance, or scale back compute to save costs.

If you don't have an Azure subscription, create a free account before you begin.

Sign in to the Azure portal

Sign in to the Azure portal.

Before you begin

You can scale a SQL pool that you already have or use Quickstart: create and connect - portal to create a SQL pool named mySampleDataWarehouse. This quickstart scales mySampleDataWarehouse.

Important

Your SQL pool must be online to scale.

Scale compute

SQL pool compute resources can be scaled by increasing or decreasing data warehouse units. The Quickstart: create and connect - portal created mySampleDataWarehouse and initialized it with 400 DWUs. The following steps adjust the DWUs for mySampleDataWarehouse.

To change data warehouse units:

  1. Click Azure Synapse Analytics (formerly SQL DW) in the left page of the Azure portal.

  2. Select mySampleDataWarehouse from the Azure Synapse Analytics (formerly SQL DW) page. The SQL pool opens.

  3. Click Scale.

    Click Scale

  4. In the Scale panel, move the slider left or right to change the DWU setting. Then select scale.

    Move Slider

Next steps

To learn more about SQL pool, continue to the Load data into SQL pool tutorial.