.show capacity command
Applies to: ✅ Azure Data Explorer
Displays capacity for data management operations. For more information, see Capacity policy.
Permissions
You must have at least Database User permissions to run this command.
Syntax
.show capacity Operation [with(``scope = cluster | workloadgroup``)]
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| Operation | string |
The name of a specific operation for which to return the capacity, as based on the capacity policy. See Supported operations. |
Supported operations
The following list outlines the operations for which you can see the capacity:
| Operation | Syntax |
|---|---|
| Data export | data-export |
| Extents merge | extents-merge |
| Extents partition | extents-partition |
| Ingestions | ingestions |
| Materialized view | materialized-view |
| Stored query results | stored-query-results |
For more information on each of the calculations, see Capacity policy.
Returns
Returns the results of a calculation for the cluster capacity for each resource.
The capacity can be based on the workload group specified in the command or the cluster's total capacity. If unspecified, the default scope is cluster.
| Output parameter | Type | Description |
|---|---|---|
| Resource | string |
The name of the resource |
| Total | Int64 | The total amount of resources, of type 'Resource', that are available. For example, the number of concurrent ingestions |
| Consumed | Int64 | The amount of resources of type 'Resource' consumed right now |
| Remaining | Int64 | The amount of remaining resources of type 'Resource' |
| Origin | Int64 | The origin of the limit on concurrent requests (capacity policy or request rate limit policy) |
Example
.show capacity ingestions
Example output
| Resource | Total | Consumed | Remaining | Origin |
|---|---|---|---|---|
| ingestions | 576 | 1 | 575 | CapacityPolicy/Ingestion |