Microsoft.Sql servers/databases/workloadGroups

Template format

To create a Microsoft.Sql/servers/databases/workloadGroups resource, add the following JSON to the resources section of your template.

{
  "name": "string",
  "type": "Microsoft.Sql/servers/databases/workloadGroups",
  "apiVersion": "2019-06-01-preview",
  "properties": {
    "minResourcePercent": "integer",
    "maxResourcePercent": "integer",
    "minResourcePercentPerRequest": "number",
    "maxResourcePercentPerRequest": "number",
    "importance": "string",
    "queryExecutionTimeout": "integer"
  }
}

Property values

The following tables describe the values you need to set in the schema.

Microsoft.Sql/servers/databases/workloadGroups object

Name Type Required Value
name string Yes The name of the workload group.
type enum Yes workloadGroups
-or-
Microsoft.Sql/servers/databases/workloadGroups

See Set name and type for child resources.
apiVersion enum Yes 2019-06-01-preview
properties object Yes Resource properties. - WorkloadGroupProperties object

WorkloadGroupProperties object

Name Type Required Value
minResourcePercent integer Yes The workload group minimum percentage resource.
maxResourcePercent integer Yes The workload group cap percentage resource.
minResourcePercentPerRequest number Yes The workload group request minimum grant percentage.
maxResourcePercentPerRequest number No The workload group request maximum grant percentage.
importance string No The workload group importance level.
queryExecutionTimeout integer No The workload group query execution timeout.