.drop workload_group 命令

适用于:✅Azure 数据资源管理器

删除工作负荷组。

权限

你必须具有群集 AllDatabasesAdmin 权限才能运行此命令。

语法

.drop workload_group WorkloadGroupName

详细了解语法约定

参数

客户 类型​​ 必需 说明
WorkloadGroupName string ✔️ 工作负荷组的名称。 可以使用括号表示法指定此名称,以对空格进行转义。 例如,['WorkLoad Group Name']。

返回

该命令在执行删除操作后返回群集中的所有工作负荷组,这是 .show workload_group 命令的输出。

下面是返回的输出的架构:

名称 Type 说明
WorkloadGroupName string 工作负荷组的名称。
WorkloadGroup string 工作负荷组的 JSON 表示形式。

示例

删除一个工作负荷组

删除 MyWorkloadGroup 工作负荷组:

.drop workload_group MyWorkloadGroup

输出

WorkloadGroupName WorkloadGroup
My Workload Group {"RequestLimitsPolicy":{"DataScope":{"IsRelaxable": true,"Value":"All"},"MaxMemoryPerQueryPerNode":{"IsRelaxable": true,"Value":6442450944},"MaxMemoryPerIterator":{"IsRelaxable": true,"Value":5368709120},"MaxFanoutThreadsPercentage":{"IsRelaxable": true,"Value":100},"MaxFanoutNodesPercentage":{"IsRelaxable": true,"Value":100},"MaxResultRecords":{"IsRelaxable": true,"Value":500000},"MaxResultBytes":{"IsRelaxable": true,"Value":67108864},"MaxExecutionTime":{"IsRelaxable": true,"Value":"00:04:00"}},"RequestRateLimitPolicies":[{"IsEnabled": true,"Scope":"WorkloadGroup","LimitKind":"ConcurrentRequests","Properties":{"MaxConcurrentRequests":100}},{"IsEnabled": true,"Scope":"Principal","LimitKind":"ConcurrentRequests","Properties":{"MaxConcurrentRequests":25}}]}
default {"RequestLimitsPolicy":{"DataScope":{"IsRelaxable": false,"Value":"HotCache"},"MaxMemoryPerQueryPerNode":{"IsRelaxable": true,"Value":8589699072},"MaxMemoryPerIterator":{"IsRelaxable": true,"Value":5368709120},"MaxFanoutThreadsPercentage":{"IsRelaxable": true,"Value":100},"MaxFanoutNodesPercentage":{"IsRelaxable": true,"Value":100},"MaxResultRecords":{"IsRelaxable": true,"Value":500000},"MaxResultBytes":{"IsRelaxable": true,"Value":67108864},"MaxExecutionTime":{"IsRelaxable":false,"Value":"00:01:00"}},"RequestRateLimitPolicies":[{"IsEnabled": true,"Scope":"WorkloadGroup","LimitKind":"ConcurrentRequests","Properties":{"MaxConcurrentRequests":100}}],"RequestRateLimitsEnforcementPolicy":{"QueriesEnforcementLevel":"QueryHead","CommandsEnforcementLevel":"Database"}}

使用方括号将工作负荷组的名称转义以删除一个工作负荷组

删除 My Workload Group 工作负荷组:

.drop workload_group ['My Workload Group']

输出

WorkloadGroupName WorkloadGroup
MyWorkloadGroup {"RequestLimitsPolicy":{"DataScope":{"IsRelaxable": true,"Value":"HotCache"},"MaxMemoryPerQueryPerNode":{"IsRelaxable":false,"Value":6442450944},"MaxMemoryPerIterator":{"IsRelaxable":false,"Value":5368709120},"MaxFanoutThreadsPercentage":{"IsRelaxable": true,"Value":100},"MaxFanoutNodesPercentage":{"IsRelaxable": true,"Value":100},"MaxResultRecords":{"IsRelaxable": true,"Value":500000},"MaxResultBytes":{"IsRelaxable": true,"Value":67108864},"MaxExecutionTime":{"IsRelaxable": true,"Value":"00:04:00"}},"RequestRateLimitPolicies":[{"IsEnabled": true,"Scope":"WorkloadGroup","LimitKind":"ConcurrentRequests","Properties":{"MaxConcurrentRequests":20}}]}
default {"RequestLimitsPolicy":{"DataScope":{"IsRelaxable":false,"Value":"HotCache"},"MaxMemoryPerQueryPerNode":{"IsRelaxable": true,"Value":8589699072},"MaxMemoryPerIterator":{"IsRelaxable": true,"Value":5368709120},"MaxFanoutThreadsPercentage":{"IsRelaxable": true,"Value":100},"MaxFanoutNodesPercentage":{"IsRelaxable": true,"Value":100},"MaxResultRecords":{"IsRelaxable": true,"Value":500000},"MaxResultBytes":{"IsRelaxable": true,"Value":67108864},"MaxExecutionTime":{"IsRelaxable":false,"Value":"00:01:00"}},"RequestRateLimitPolicies":[{"IsEnabled": true,"Scope":"WorkloadGroup","LimitKind":"ConcurrentRequests","Properties":{"MaxConcurrentRequests":100}}],"RequestRateLimitsEnforcementPolicy":{"QueriesEnforcementLevel":"QueryHead","CommandsEnforcementLevel":"Database"}}

备注

不能删除 internaldefault 工作负荷组。 尝试删除其中任一工作负荷组都会中止该命令,并会显示一条错误,其中指出原因。