Quickstart: Scale compute in Azure SQL Data Warehouse in the Azure portal
Scale compute in Azure SQL Data Warehouse in 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 data warehouse that you already have, or use Quickstart: create and Connect - portal to create a data warehouse named mySampleDataWarehouse. This quickstart scales mySampleDataWarehouse.
In SQL Data Warehouse, you can increase or decrease compute resources by adjusting data warehouse units. The 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:
- Click SQL databases in the left page of the Azure portal.
- Select mySampleDataWarehouse from the SQL databases page. The data warehouse opens.
In the Scale panel, move the slider left or right to change the DWU setting.
Click Save. A confirmation message appears. Click yes to confirm or no to cancel.
You have now learned how to scale compute for your data warehouse. To learn more about Azure SQL Data Warehouse, continue to the tutorial for loading data.