Skip to content

quickstart-scale-compute-workspace-portal.md

Latest commit

 

History

History
57 lines (39 loc) · 3.83 KB

quickstart-scale-compute-workspace-portal.md

File metadata and controls

57 lines (39 loc) · 3.83 KB
title Quickstart: Scale compute for an Azure Synapse dedicated SQL pool in a Synapse workspace with the Azure portal
description Learn how to scale compute for an Azure Synapse dedicated SQL pool in a Synapse workspace with the Azure portal.
author ajagadish-24
ms.author ajagadish
ms.date 02/22/2023
ms.service azure-synapse-analytics
ms.subservice sql-dw
ms.topic quickstart
ms.custom
azure-synapse
mode-ui
sfi-image-nochange

Quickstart: Scale compute for an Azure Synapse dedicated SQL pool in a Synapse workspace with the Azure portal

You can scale compute for an Azure Synapse dedicated SQL pool in a Synapse workspace 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 Azure account before you begin.

Note

This article applies to dedicated SQL pools created in Azure Synapse Analytics workspaces. This content does not apply to dedicated SQL pools (formerly SQL DW) or dedicated SQL pools (formerly SQL DW) in connected workspaces. For similar instructions for dedicated SQL pools (formerly SQL DW), see Quickstart: Scale compute for an Azure Synapse dedicated SQL pool (formerly SQL DW) with the Azure portal. For more on the differences between dedicated SQL pools (formerly SQL DW) and dedicated SQL pools in Azure Synapse Workspaces, read What's the difference between Azure Synapse (formerly SQL DW) and Azure Synapse Analytics Workspace.

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. Select Azure Synapse Analytics in the left page of the Azure portal.

  2. Under Analytical pools, select SQL pools from the main menu.

  3. Select mySampleDataWarehouse from the list of pools. The SQL pool opens.

  4. Select Scale from the navigation menu.

    :::image type="content" source="./media/quickstart-scale-compute-workspace-portal/scale-dedicated-sql-pool-azure-portal.png" alt-text="A screenshot of the Azure portal showing the Scale button on the Overview page of a dedicated SQL pool." lightbox="./media/quickstart-scale-compute-workspace-portal/scale-dedicated-sql-pool-azure-portal.png":::

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

    :::image type="content" source="./media/quickstart-scale-compute-workspace-portal/dedicated-sql-pool-scale-slider-azure-portal.png" alt-text="A screenshot of the Azure portal showing the Scale slider on the Scale page of a dedicated SQL pool in an Azure Synapse workspace." lightbox="./media/quickstart-scale-compute-workspace-portal/dedicated-sql-pool-scale-slider-azure-portal.png":::

Next steps