英文:
How to increase DWUs on Azure Synapse Dedicated SQL Pool
问题
I inherited an Azure Dedicated SQL Pool at my current firm. The DWU was set at 100, is there a way to increase the DWU's? It would be appear I would have to create a new Dedicated SQL Pool to increase the DWU's.
Also, is there a guide showing what DWU's are best for a particular environments? For example, Microsoft recommend a minimum of 1100 DWUs for production, but I'm not sure what production environment that is based on?
英文:
I inherited an Azure Dedicated SQL Pool at my current firm. The DWU was set at 100, is there a way to increase the DWU's? It would be appear I would have to create a new Dedicated SQL Pool to increaase the DWU's
Also, is there a guide showing what DWU's are best for a particular environments? For example, Microsoft recommend a minimum of 1100 DWUs for production, but I'm not sure what production environment that is based on?
答案1
得分: 1
- 在Azure门户中，单击需要增加DWU的专用SQL资源。
- 然后单击Scale。
- 接着，根据需求增加DWU。
您还可以使用T-SQL命令或PowerShell来更改DWU。
参考文档： Microsoft文档 关于更改DWU。
英文:
- In Azure portal, Click the dedicated SQL resource where you need to increase DWUs.
- Then click Scale
- Then, Increase the DWU based on the requirement.
You can also use t-sql command, powershell to change DWUs.
Reference: Microsoft document on Changing DWUs
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论