.alter-merge workload_group

Alters a workload group. This command requires AllDatabasesAdmin permission.

For more information, see Workload groups. To show the current workload group settings, use the .show command.

Syntax

.alter-merge workload_group WorkloadGroupName SerializedPolicyObject

Arguments

Examples

Alter specific limits in the request limits policy

Alter specific limits in the request limits policy of the default workload group, while keeping previously defined limits unchanged:

.alter-merge workload_group default ```
{
  "RequestLimitsPolicy": {
    "DataScope": {
      "IsRelaxable": false,
      "Value": "HotCache"
    },
    "MaxExecutionTime": {
      "IsRelaxable": false,
      "Value": "00:01:00"
    }
  }
} ```

Alter the request rate limit policies

Alter the request rate limit policies of the default workload group, while keeping all of its other policies unchanged:

.alter-merge workload_group default ```
{
  "RequestRateLimitPolicies": [
    {
      "IsEnabled": true,
      "Scope": "WorkloadGroup",
      "LimitKind": "ConcurrentRequests",
      "Properties": {
        "MaxConcurrentRequests": 100
      }
    }
  ]
} ```

Alter the request queuing policy

Enable request queuing for the default workload group, while keeping its request limits policy and request rate limit policies unchanged:

.alter-merge workload_group default ```
{
  "RequestQueuingPolicy": {
      "IsEnabled": true
  }
} ```

Alter the request rate limits enforcement policy

Enable request rate limits enforcement policy for the default workload group, while keeping all of its other policies unchanged:

.alter-merge workload_group default ```
{
  "RequestRateLimitsEnforcementpolicy": {
      "QueriesEnforcementLevel": "QueryHead",
      "CommandsEnforcementLevel": "Cluster"
  }
} ```

Alter the query consistency policy

Specify the appliable option for the query consistency model:

.alter-merge workload_group default ```
{
  "QueryConsistencyPolicy": {
     "QueryConsistency": {
        "IsRelaxable": true,
        "Value": "Weak"
     }
  }
} ```