0

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

enter image description here

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?

Patterson
  • 1,927
  • 1
  • 19
  • 56

1 Answers1

1
  • In Azure portal, Click the dedicated SQL resource where you need to increase DWUs.

enter image description here

  • Then click Scale

enter image description here

  • Then, Increase the DWU based on the requirement.

enter image description here

You can also use t-sql command, powershell to change DWUs.

Reference: Microsoft document on Changing DWUs

Aswin
  • 4,090
  • 2
  • 4
  • 16
  • Hi @Aswin, thanks for reaching out. I just realised that the Dedicated SQL pools need to be online to configure workload management ... duh! Thanks anyway – Patterson Feb 08 '23 at 10:20