.alter cluster policy capacity command

Switch services using the Version drop-down list. Learn more about navigation.
Applies to: ✅ Azure Data Explorer

Warning

This command is deprecated and will be disabled soon. Use alter-merge instead.

Changes the cluster's capacity policy. A capacity policy controls the computational resources for data management operations on the cluster.

Note

  • Changes to the cluster capacity policy could take up to 1 hour to take effect.
  • All properties other than the ones specified in the command are reset to their default values. To change some properties, while keeping the others intact, use .alter-merge cluster policy capacity command.

Permissions

You must have AllDatabasesAdmin permissions to run this command.

Syntax

.alter cluster policy capacity PolicyObject

Learn more about syntax conventions.

Parameters

Name Type Required Description
PolicyObject string ✔️ A JSON policy object. See capacity policy for policy properties.

Returns

Returns a JSON representation of the policy.

Example

Alter the capacity policy. The resulting policy is the properties in the command's input merged with the default capacity policy.

.alter cluster policy capacity ```
{
  "IngestionCapacity": {
    "ClusterMaximumConcurrentOperations": 512,
    "CoreUtilizationCoefficient": 0.75
  }
}```

Output

"PolicyName": CapacityPolicy,
"EntityName": ,
"Policy": {
  "IngestionCapacity": {
    "ClusterMaximumConcurrentOperations": 512,
    "CoreUtilizationCoefficient": 0.75
  },
  "ExtentsMergeCapacity": {
    "MinimumConcurrentOperationsPerNode": 1,
    "MaximumConcurrentOperationsPerNode": 5
  },
  "ExtentsPurgeRebuildCapacity": {
    "MaximumConcurrentOperationsPerNode": 1
  },
  "ExportCapacity": {
    "ClusterMaximumConcurrentOperations": 100,
    "CoreUtilizationCoefficient": 0.25
  },
  "ExtentsPartitionCapacity": {
    "ClusterMinimumConcurrentOperations": 1,
    "ClusterMaximumConcurrentOperations": 32
  },
  "StreamingIngestionPostProcessingCapacity": {
    "MaximumConcurrentOperationsPerNode": 4
  },
  "MaterializedViewsCapacity": {
    "ClusterMinimumConcurrentOperations": 1,
    "ClusterMaximumConcurrentOperations": 10,
    "ExtentsRebuildCapacity": {
      "ClusterMaximumConcurrentOperations": 50,
      "MaximumConcurrentOperationsPerNode": 5
    }
  },
  "StoredQueryResultsCapacity": {
    "MaximumConcurrentOperationsPerDbAdmin": 250,
    "CoreUtilizationCoefficient": 0.75
  },
  "PurgeStorageArtifactsCleanupCapacity": {
    "MaximumConcurrentOperationsPerCluster": 1
  },
  "PeriodicStorageArtifactsCleanupCapacity": {
    "MaximumConcurrentOperationsPerCluster": 1
  },
  "QueryAccelerationCapacity": {
    "ClusterMaximumConcurrentOperations": 100,
    "CoreUtilizationCoefficient": 0.5
  }
},
"ChildEntities": ,
"EntityType": ,
  • Last updated on