Creating workload groups for advanced workload management

Workload groups in Synapse dedicated pools allow you to define resource pools with custom resource allocation percentages compared to the predefined percentages offered by resource classes. Additionally, workload groups offer the flexibility to set minimum and maximum resource percentages for the entire pool and also for each request. Setting a minimum resource percentage for a workload group ensures there will always be a percentage of resource reserved for the queries mapped to the resource group. In this recipe, we will define a custom resource group with minimum and maximum resource percentages for the pool and for each request, and we will also classify it in such a way that the resource allocation changes depending on the time of query execution.

Getting ready

Create a Synapse Analytics workspace as explained in the Provisioning an Azure Synapse Analytics workspace recipe of Chapter 8, Processing Data Using Azure...