Microsoft.Sql servers/databases/workloadGroups 2020-08-01-preview

The servers/databases/workloadGroups resource type can be deployed to: Resource groups.

To learn about resource group deployments, see Bicep or ARM template.

Template format

To create a Microsoft.Sql/servers/databases/workloadGroups resource, add the following Bicep or JSON to your template.

resource symbolicname 'Microsoft.Sql/servers/databases/workloadGroups@2020-08-01-preview' = {
  name: 'string'
  properties: {
    importance: 'string'
    maxResourcePercent: int
    maxResourcePercentPerRequest: int
    minResourcePercent: int
    minResourcePercentPerRequest: int
    queryExecutionTimeout: int
  }
}

Property values

servers/databases/workloadGroups

Name Description Value
type The resource type

For Bicep, set this value in the resource declaration.
'Microsoft.Sql/servers/databases/workloadGroups'
apiVersion The resource api version

For Bicep, set this value in the resource declaration.
'2020-08-01-preview'
name The resource name string (required)

See how to set names and types for child resources in Bicep or JSON ARM templates.
properties Workload group definition. For more information look at sys.workload_management_workload_groups (DMV). WorkloadGroupProperties

WorkloadGroupProperties

Name Description Value
importance The workload group importance level. string
maxResourcePercent The workload group cap percentage resource. int (required)
maxResourcePercentPerRequest The workload group request maximum grant percentage. int
minResourcePercent The workload group minimum percentage resource. int (required)
minResourcePercentPerRequest The workload group request minimum grant percentage. int (required)
queryExecutionTimeout The workload group query execution timeout. int