Exam DP203 SQL Management: Difference between revisions
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
In SQL pools, the unit of scale is an abstraction of compute power that is known as a '''DWU -''' '''data warehouse unit''' | In SQL pools, the unit of scale is an abstraction of compute power that is known as a '''DWU -''' '''data warehouse unit''' | ||
You can scale a Synapse SQL pool through: | You can scale a '''Synapse SQL''' '''dedicated''' pool through: | ||
# '''Azure portal''' (click on Scale, then drag a slider) | # '''Azure portal''' (click on Scale, then drag a slider) | ||
| Line 9: | Line 9: | ||
# '''TSQL''': ALTER DATABASE mySampleDataWarehouse MODIFY (SERVICE_OBJECTIVE = 'DW300c') | # '''TSQL''': ALTER DATABASE mySampleDataWarehouse MODIFY (SERVICE_OBJECTIVE = 'DW300c') | ||
# '''PowerShell''': Set-AzSqlDatabase -ResourceGroupName "resourcegroupname" -DatabaseName "mySampleDataWarehouse" -ServerName "sqlpoolservername" -RequestedServiceObjectiveName "DW300c" | # '''PowerShell''': Set-AzSqlDatabase -ResourceGroupName "resourcegroupname" -DatabaseName "mySampleDataWarehouse" -ServerName "sqlpoolservername" -RequestedServiceObjectiveName "DW300c" | ||
To do the same with '''Spark pools''', you can also click "Scale". Note you can also apply '''autoscale'''. (I don't think you can autoscale with SQL dedicated pools). | |||
Revision as of 20:45, 18 November 2024
SQL Pool management
In SQL pools, the unit of scale is an abstraction of compute power that is known as a DWU - data warehouse unit
You can scale a Synapse SQL dedicated pool through:
- Azure portal (click on Scale, then drag a slider)
- Synapse Studio (also right-click- scale + slider)
- TSQL: ALTER DATABASE mySampleDataWarehouse MODIFY (SERVICE_OBJECTIVE = 'DW300c')
- PowerShell: Set-AzSqlDatabase -ResourceGroupName "resourcegroupname" -DatabaseName "mySampleDataWarehouse" -ServerName "sqlpoolservername" -RequestedServiceObjectiveName "DW300c"
To do the same with Spark pools, you can also click "Scale". Note you can also apply autoscale. (I don't think you can autoscale with SQL dedicated pools).