Exam DP203 SQL Management: Difference between revisions
Created page with "SQL Pool management" |
No edit summary |
||
| Line 1: | Line 1: | ||
SQL Pool management | 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 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" | |||
Revision as of 20:39, 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 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"