Diagnostic information

These commands can be used to display system diagnostic information.

• .show capacity
• .show operations

.show capacity

.show capacity [with(scope = cluster | workloadgroup)]

Returns the results of a calculation for an estimated cluster capacity for each resource.

scope controls the basis on which the capacities are shown. The capacity can be based on the workload group the command was classified to, or the cluster's total capacity. If unspecified, the default scope is cluster.

Results

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

Resource	Total	Consumed	Remaining	Origin
ingestions	576	1	575	CapacityPolicy/Ingestion

.show operations

This command returns a table containing all the administrative operations since the new Admin node was elected.

Syntax option	Description
.show operations	Returns all operations that the cluster is processing or have processed
.show operations OperationId	Returns the operation status for a specific ID
.show operations (OperationId1, OperationId2, ...)	Returns operations status for specific IDs

Results

Output parameter	Type	Description
ID	String	Operation identifier
Operation	String	Admin command alias
NodeId	String	If the command is running something remotely, such as DataIngestPull. The node ID will contain the ID of the remote node that is running
StartedOn	DateTime	Date/time (in UTC) when the operation started
LastUpdatedOn	DateTime	Date/time (in UTC) when the operation last updated. The operation can either be a step inside the operation, or a completion step
Duration	DateTime	Time span between LastUpdateOn and StartedOn
State	String	Command state, with values "InProgress", "Completed", or "Failed"
Status	String	Additional help string that contains the errors for failed operations

Example

ID	Operation	Node ID	Started On	Last Updated On	Duration	State	Status
3827def6-0773-4f2a-859e-c02cf395deaf	SchemaShow		2015-01-06 08:47:01.0000000	2015-01-06 08:47:01.0000000	0001-01-01 00:00:00.0000000	Completed
841fafa4-076a-4cba-9300-4836da0d9c75	DataIngestPull	Kusto.Azure.Svc_IN_1	2015-01-06 08:47:02.0000000	2015-01-06 08:48:19.0000000	0001-01-01 00:01:17.0000000	Completed
e198c519-5263-4629-a158-8d68f7a1022f	OperationsShow		2015-01-06 08:47:18.0000000	2015-01-06 08:47:18.0000000	0001-01-01 00:00:00.0000000	Completed
a9f287a1-f3e6-4154-ad18-b86438da0929	ExtentsDrop		2015-01-11 08:41:01.0000000	0001-01-01 00:00:00.0000000	0001-01-01 00:00:00.0000000	InProgress
9edb3ecc-f4b4-4738-87e1-648eed2bd998	DataIngestPull		2015-01-10 14:57:41.0000000	2015-01-10 14:57:41.0000000	0001-01-01 00:00:00.0000000	Failed	Collection was modified. Enumeration operation may not run