.drop workload_group kommando
Gäller för: ✅Microsoft Fabric✅Azure Data Explorer
Släpp en arbetsbelastningsgrupp.
Behörigheter
Du måste ha behörigheten Cluster AllDatabasesAdmin för att kunna köra det här kommandot.
Not
Rollen admin ärver Cluster AllDatabasesAdmin behörigheter.
Syntax
.drop
workload_group
WorkloadGroupName
Läs mer om syntaxkonventioner.
Parametrar
| Namn | Typ | Krävs | Beskrivning |
|---|---|---|---|
| WorkloadGroupName | string |
✔️ | Namnet på arbetsbelastningsgruppen. Det här namnet kan anges med hakparentes notation till escape-blanksteg. Till exempel ['WorkLoad Group Name']. |
Returnerar
Kommandot returnerar alla arbetsbelastningsgrupper i klustret efter släppet, vilket är utdata från kommandot .show workload_group.
Kommandot returnerar alla arbetsbelastningsgrupper i Eventhouse efter släppet, vilket är utdata från kommandot .show workload_group.
Följande är schemat för de utdata som returneras:
| Namn | Typ | Beskrivning |
|---|---|---|
| WorkloadGroupName | string |
Namnet på arbetsbelastningsgruppen. |
| WorkloadGroup | string |
JSON-representation av arbetsbelastningsgruppen. |
Exempel
Ta bort en arbetsbelastningsgrupp
Ta bort MyWorkloadGroup arbetsbelastningsgrupp:
.drop workload_group MyWorkloadGroup
utdata
| WorkloadGroupName | WorkloadGroup |
|---|---|
| Min arbetsbelastningsgrupp | {"RequestLimitsPolicy":{"DataScope":{"IsRelaxable": true,"Value":"All"},"MaxMemoryPerQueryPerNode":{"IsRelaxable": true,"Value":6442450944},"MaxMemoryPerIterator":{"IsRelaxable": true,"Value":5368709120},"MaxFanoutThreadsPercentage":{"IsRelaxable": true,"Value":5368709120},"MaxFanoutThreadsPercentage":{"IsRelaxable": true ": 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}}]} |
| standard | {"RequestLimitsPolicy":{"DataScope":{"IsRelaxable": false,"Value":"HotCache"},"MaxMemoryPerQueryPerNode":{"IsRelaxable": true,"Value":8589699072},"MaxMemoryPerIterator":{"IsRelaxable": true,"Value":5368709120},"MaxFanoutThreadsPercentage":{"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"}} |
Släpp en arbetsbelastningsgrupp som undfly sitt namn med hakparenteser
Ta bort My Workload Group arbetsbelastningsgrupp:
.drop workload_group ['My Workload Group']
utdata
| WorkloadGroupName | WorkloadGroup |
|---|---|
| MyWorkloadGroup | {"RequestLimitsPolicy":{"DataScope":{"IsRelaxable": true,"Value":"HotCache"},"MaxMemoryPerQueryPerNode":{"IsRelaxable":false,"Value":6442450944},"MaxMemoryPerIterator":{"IsRelaxable":false,"Value":5368709120},"MaxFanoutThreadsPercentage":{"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}}]} |
| standard | {"RequestLimitsPolicy":{"DataScope":{"IsRelaxable":false,"Value":"HotCache"},"MaxMemoryPerQueryPerNode":{"IsRelaxable": true,"Value":8589699072},"MaxMemoryPerIterator":{"IsRelaxable": true,"Value":5368709120},"MaxFanoutThreadsPercentage":{"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"}} |
Anmärkningar
Det går inte att ta bort arbetsbelastningsgrupperna internal och default. Ett försök att släppa någon av dem avbryter kommandot med ett fel som anger orsaken.