Quickstart: Scale compute for dedicated SQL pools in Azure Synapse Workspaces with Azure PowerShell
Article
You can scale compute for Azure Synapse Analytics dedicated SQL pools using Azure PowerShell. 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. There are different PowerShell cmdlets to use for each, for example, use Set-AzSqlDatabase for a dedicated SQL pool (formerly SQL DW), but Update-AzSynapseSqlPool for a dedicated SQL pool in an Azure Synapse Workspace. For similar instructions for dedicated SQL pools (formerly SQL DW), see Quickstart: Scale compute for dedicated SQL pools (formerly SQL DW) using Azure PowerShell.
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.
Search for Azure Synapse Analytics in the search bar of the Azure portal.
Select your Synapse workspace from the list.
Select SQL pools under Analytics pools in the menu list.
If you see the message The dedicated pools listed below are hosted on the connected SQL Server, your dedicated SQL pool (formerly SQL DW) is in a Connected workspace. Stop, and instead use the PowerShell examples in Quickstart: Scale compute for dedicated SQL pool (formerly SQL DW) with Azure PowerShell. Proceed for dedicated SQL pools created in a Synapse workspace.
Select the name of your dedicated SQL pool from the Synapse workspace | SQL pools page. In the following samples, we use contoso_dedicated_sql_pool.
As in the following image, we use contoso-synapse-workspace as the Azure Synapse workspace name in the following PowerShell samples, in the resource group contoso.
For example, to retrieve the properties and status of a dedicated SQL pool created in a Synapse workspace:
You can increase or decrease compute resources by adjusting the dedicated SQL pool's data warehouse units. The Workload management menu of the Azure portal provides scaling, but this can also be accomplished with PowerShell.
To change data warehouse units, use the Update-AzSynapseSqlPool PowerShell cmdlet. The following example sets the data warehouse units to DW300c for the database contoso_dedicated_sql_pool, which is hosted in the resource group contoso in the Synapse workspace contoso-synapse-workspace.
The PowerShell cmdlet will begin the scaling operation. Use the Get-AzSynapseSqlPool cmdlet to observe the progress of the scaling operation. For example, you will see Status reported as "Scaling". Eventually, the pool will report the new Sku value and Status of "Online".
You have now learned how to scale compute for dedicated SQL pool in a Synapse workspace. To learn more about dedicated SQL pools, continue to the tutorial for loading data.
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Scale compute in dedicated SQL pool (formerly SQL DW) using T-SQL and SQL Server Management Studio (SSMS). Scale out compute for better performance, or scale back compute to save costs.