.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
WorkloadGroupName - Name of the workload group. Can be escaped with bracket notation ['WorkLoadGroupName'].
SerializedPolicyObject - Define a policy object. The following policies apply to workload groups:
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"
}
}
} ```