Delen via

Opdracht .drop workload_group

  • Artikel

Van toepassing op: ✅Microsoft Fabric✅Azure Data Explorer-

Een workloadgroep verwijderen.

Machtigingen

U moet beschikken over Cluster AllDatabasesAdmin--machtigingen om deze opdracht uit te voeren.

Notitie

De admin rol neemt Cluster AllDatabasesAdmin machtigingen over.

Syntaxis

.drop workload_group WorkloadGroupName-

Meer informatie over syntaxisconventies.

Parameters

Naam Type Vereist Beschrijving
WorkloadGroupName- string ✔️ De naam van de workloadgroep. Deze naam kan worden opgegeven met een haak-notatie voor escape-spaties. Bijvoorbeeld ['WorkLoad-groepsnaam'].

Retourneert

De opdracht retourneert alle workloadgroepen in het cluster, na de neerval, de uitvoer van de opdracht .show workload_group.

De opdracht retourneert alle workloadgroepen in Eventhouse, na de drop, de uitvoer van de opdracht .show workload_group.

Hier volgt het schema van de geretourneerde uitvoer:

Naam Type Beschrijving
WorkloadGroupName string Naam van de workloadgroep.
WorkloadGroup string JSON-weergave van de workloadgroep.

Voorbeelden

Eén workloadgroep verwijderen

Verwijder MyWorkloadGroup workloadgroep:

.drop workload_group MyWorkloadGroup

uitvoer

WorkloadGroupName WorkloadGroup
Mijn workloadgroep {"RequestLimitsPolicy":{"DataScope":{"IsRelaxable": true,"Value":"All"},"MaxMemoryPerQueryPerNode":{"IsRelaxable": true,"True,"All"},"MaxMemoryPerQueryPerNode":{"IsRelaxable": true,"Waarde":6442450944},"MaxMemoryPerIterator":{"IsRelaxable": true,"Value":5368709120},"MaxFanoutThreadsPercentage":{"IsRelaxable":xable": true,"Value":100},"MaxFanoutNodesPercentage":{"IsRelaxable": true,"Value":100},"MaxResultRecords":{""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}}]}
verstek {"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":5000000},"MaxResultBytes":{"IsRelaxable": true,"Value":67108864}," MaxExecutionTime":{"IsRelaxable":false,"Value":"00:01:00"}},"RequestRateLimitPolicies":[{"IsEnabled": true,"Scope":"WorkloadGroup","LimitKind":""ConcurrentRequests","Properties":{"MaxConcurrentRequests":100}}],"RequestRateLimitsEnforcementPolicy":{"QuerysEnforcementLevel":"QueryHead","CommandsEnforcementLevel":"Database"}}

Eén workloadgroep verwijderen die de naam met vierkante haken afwijkt

Verwijder My Workload Group workloadgroep:

.drop workload_group ['My Workload Group']

uitvoer

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":5000000},"MaxResultBytes":{"IsRelaxable": true,"Value":67108864}," MaxExecutionTime":{"IsRelaxable": true,"Value":"00:04:00"}},"RequestRateLimitPolicies":[{"IsEnabled": true,"Scope":"WorkloadGroup","LimitKind":"ConcurrentRequests","Properties":{"MaxConcurrentRequests"::20}}]}
verstek {"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":{"QuerysEnforcementLevel":"QueryHead","CommandsEnforcementLevel":"Database"}}

Opmerkingen

De internal- en default-workloadgroepen kunnen niet worden verwijderd. Een poging om een van beide af te breken, wordt de opdracht afgebroken met een fout die de reden aangeeft.

Verwante inhoud