'upscaling synapse dedicated sql pool using powershell
I want to upscale dedicated SQL pools in the synapse workspace using PowerShell but cannot find commands. can anyone provide any link or code?
Solution 1:[1]
Azure Synapse Analytics dedicated sql pool scaling using powershell
In dedicated SQL pool (formerly SQL DW), you can increase or decrease compute resources by adjusting data warehouse units. The Create and Connect - portal created
mySampleDataWarehouseand initialized it with 400 DWUs. The following steps adjust the DWUs formySampleDataWarehouse.To change data warehouse units, use the Set-AzSqlDatabase PowerShell cmdlet. The following example sets the data warehouse units to DW300c for the database
mySampleDataWarehouse, which is hosted in the Resource groupresourcegroupnameon serversqlpoolservername.
Set-AzSqlDatabase -ResourceGroupName "resourcegroupname" -DatabaseName "mySampleDataWarehouse" -ServerName "sqlpoolservername" -RequestedServiceObjectiveName "DW300c"
You can refer to Scale compute for dedicated SQL pool (formerly SQL DW) with Azure PowerShell
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |