诊断信息Diagnostic information
这些命令可用于显示系统诊断信息。These commands can be used to display system diagnostic information.
.show cluster.show cluster
.show cluster
返回一个集，该集包含群集中当前处于活动状态的每个节点的一条记录。Returns a set that contains one record for each node that is currently active in the cluster.
结果Results
| 输出列Output column | 类型Type | 说明Description |
|---|---|---|
| NodeIdNodeId | StringString | 标识节点。Identifies the node. 如果在 Azure 中部署了该群集，则节点 ID 就是节点的 Azure RoleIdThe node ID is the Azure RoleId of the node, if the cluster is deployed in Azure |
| 地址Address | StringString | 由群集用于进行节点间通信的内部终结点The internal endpoint used by the cluster for inter-node communications |
| 名称Name | StringString | 节点的内部名称。An internal name for the node. 名称包括计算机名称、进程名称和进程 IDThe name includes the machine name, process name, and process ID |
| StartTimeStartTime | DateTimeDateTime | 节点中当前的 Kusto 实例化开始的日期/时间（以 UTC 为单位）。The date/time (in UTC) that the current Kusto instantiation in the node started. 此值可用于检测节点（或在该节点上运行的 Kusto）最近是否重启This value can be used to detect if the node (or Kusto running on the node) was recently restarted |
| IsAdminIsAdmin | 布尔Boolean | 如果此节点当前是群集的“领导者”If this node is currently the "leader" of the cluster |
| MachineTotalMemoryMachineTotalMemory | Int64Int64 | 节点的 RAM 容量。The node's RAM amount. |
| MachineAvailableMemoryMachineAvailableMemory | Int64Int64 | 当前可在节点上使用的 RAM 容量。The RAM amount that is currently available for use on the node. |
| ProcessorCountProcessorCount | Int32Int32 | 节点上处理器的数量。The number of processors on the node. |
| EnvironmentDescriptionEnvironmentDescription | stringstring | 有关将节点环境序列化为 JSON 的其他信息。Additional information about the node's environment serialized as JSON. 例如升级/容错域For example, as Upgrade/Fault Domains |
示例Example
.show cluster
| NodeIDNodeID | 地址Address | 名称Name | StartTimeStartTime | IsAdminIsAdmin | MachineTotalMemoryMachineTotalMemory | MachineAvailableMemoryMachineAvailableMemory | ProcessorCountProcessorCount | EnvironmentDescriptionEnvironmentDescription |
|---|---|---|---|---|---|---|---|---|
| Kusto.Azure.Svc_IN_1Kusto.Azure.Svc_IN_1 | net.tcp://100.112.150.30:23107/net.tcp://100.112.150.30:23107/ | Kusto.Azure.Svc_IN_4/RD000D3AB1E9BD/WaWorkerHost/3820Kusto.Azure.Svc_IN_4/RD000D3AB1E9BD/WaWorkerHost/3820 | 2016-01-15 02:00:22.65221522016-01-15 02:00:22.6522152 | TrueTrue | 274877435904274877435904 | 247797796864247797796864 | 1616 | {"UpdateDomain":0, "FaultDomain":0}{"UpdateDomain":0, "FaultDomain":0} |
| Kusto.Azure.Svc_IN_3Kusto.Azure.Svc_IN_3 | net.tcp://100.112.154.34:23107/net.tcp://100.112.154.34:23107/ | Kusto.Azure.Svc_IN_3/RD000D3AB1E062/WaWorkerHost/2760Kusto.Azure.Svc_IN_3/RD000D3AB1E062/WaWorkerHost/2760 | 2016-01-15 05:52:52.14346832016-01-15 05:52:52.1434683 | FalseFalse | 274877435904274877435904 | 258740346880258740346880 | 1616 | {"UpdateDomain":1, "FaultDomain":1}{"UpdateDomain":1, "FaultDomain":1} |
| Kusto.Azure.Svc_IN_2Kusto.Azure.Svc_IN_2 | net.tcp://100.112.128.40:23107/net.tcp://100.112.128.40:23107/ | Kusto.Azure.Svc_IN_2/RD000D3AB1E054/WaWorkerHost/3776Kusto.Azure.Svc_IN_2/RD000D3AB1E054/WaWorkerHost/3776 | 2016-01-15 07:17:18.06997902016-01-15 07:17:18.0699790 | FalseFalse | 274877435904274877435904 | 244232339456244232339456 | 1616 | {"UpdateDomain":2, "FaultDomain":2}{"UpdateDomain":2, "FaultDomain":2} |
| Kusto.Azure.Svc_IN_0Kusto.Azure.Svc_IN_0 | net.tcp://100.112.138.15:23107/net.tcp://100.112.138.15:23107/ | Kusto.Azure.Svc_IN_0/RD000D3AB0D6C6/WaWorkerHost/3208Kusto.Azure.Svc_IN_0/RD000D3AB0D6C6/WaWorkerHost/3208 | 2016-01-15 09:46:36.98650162016-01-15 09:46:36.9865016 | FalseFalse | 274877435904274877435904 | 238414581760238414581760 | 1616 | {"UpdateDomain":3, "FaultDomain":3}{"UpdateDomain":3, "FaultDomain":3} |
.show diagnostics.show diagnostics
.show diagnostics [with(scope = cluster | workloadgroup)]
返回有关 Kusto 群集运行状况的信息。Returns information about the Kusto cluster state of health.
scope 控制显示容量的基础。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. 如果未指定范围，则默认为 workloadgroup。If unspecified, the default scope is workloadgroup.
返回Returns
| 输出参数Output parameter | 类型Type | 说明Description |
|---|---|---|
| IsHealthyIsHealthy | 布尔Boolean | 群集是否正常运行If the cluster is healthy or not |
| IsScaleOutRequiredIsScaleOutRequired | 布尔Boolean | 是否应通过添加更多计算节点来增加群集的大小If the cluster should be increased in size by adding more computing nodes |
| MachinesTotalMachinesTotal | Int64Int64 | 群集中的计算机数The number of machines in the cluster |
| MachinesOfflineMachinesOffline | Int64Int64 | 当前处于脱机状态的计算机数The number of machines that are currently offline |
| NodeLastRestartedOnNodeLastRestartedOn | DateTimeDateTime | 群集中的任何节点上次重启的日期/时间The last date/time any node in the cluster restarted |
| AdminLastElectedOnAdminLastElectedOn | DateTimeDateTime | 群集管理员角色的所有权上次更改的日期/时间The last date/time ownership of the cluster admin role changed |
| MemoryLoadFactorMemoryLoadFactor | DoubleDouble | 群集所容纳的数据量（相对于其最大容量 100.0）The amount of data held by the cluster, relative to its maximum capacity of 100.0 |
| ExtentsTotalExtentsTotal | Int64Int64 | 群集当前在所有数据库和所有表中拥有的数据盘区总数The total number of data extents that the cluster currently has, across all databases and all tables |
| 保留Reserved | Int64Int64 | |
| 保留Reserved | Int64Int64 | |
| InstancesTargetBasedOnDataCapacityInstancesTargetBasedOnDataCapacity | Int64Int64 | 使 ClusterDataCapacityFactor 低于 80 所需的实例数。The number of instances needed to bring the ClusterDataCapacityFactor below 80. 该值仅在所有计算机大小相同时才有效THis value is only valid when all machines are sized the same |
| TotalOriginalDataSizeTotalOriginalDataSize | Int64Int64 | 最初引入数据的总大小（以字节为单位）Total size of the originally ingested data in bytes |
| TotalExtentSizeTotalExtentSize | Int64Int64 | 压缩和编制索引后的存储数据的总大小（以字节为单位）Total size of the stored data, after compression and indexing in bytes |
| IngestionsLoadFactorIngestionsLoadFactor | DoubleDouble | 使用的群集引入容量的百分比。The percentage of the cluster ingestion capacity that was used. 使用 .show capacity 命令可查看最大容量The maximum capacity can be seen using the .show capacity command |
| IngestionsInProgressIngestionsInProgress | Int64Int64 | 当前正在执行的引入操作数The number of ingestion operations currently being done |
| IngestionsSuccessRateIngestionsSuccessRate | DoubleDouble | 在前 10 分钟内成功完成的引入操作的百分比The percentage of ingestion operations that completed successfully in the previous 10 minutes |
| MergesInProgressMergesInProgress | Int64Int64 | 当前正在执行的盘区合并操作数The number of extents merge operations currently being done |
| BuildVersionBuildVersion | StringString | 部署到群集的 Kusto 软件版本The Kusto software version deployed to the cluster |
| BuildTimeBuildTime | DateTimeDateTime | Kusto 软件的内部版本的日期/时间。The date/time of the Kusto software's build version. |
| ClusterDataCapacityFactorClusterDataCapacityFactor | DoubleDouble | 使用的群集数据容量的百分比。The percentage of the cluster data capacity used. 百分比的计算方式是：SUM（盘区大小数据）/SUM（SSD 缓存大小）。The percentage is calculated as SUM(Extent Size Data) / SUM(SSD Cache Size). |
| IsDataWarmingRequiredIsDataWarmingRequired | 布尔Boolean | 内部：是否应运行群集的预热查询以将数据引入本地 SSD 缓存Internal: If the cluster's warming queries should be run, to bring data to local SSD cache |
| DataWarmingLastRunOnDataWarmingLastRunOn | DateTimeDateTime | 最后在群集上运行 .warm 数据的日期/时间The last date/time that .warm data was run on the cluster |
| MergesSuccessRateMergesSuccessRate | DoubleDouble | 在前 10 分钟内成功完成的合并操作的百分比。The percentage of merge operations that completed successfully in the previous 10 minutes. |
| NotHealthyReasonNotHealthyReason | StringString | 指定群集运行不正常的原因Specifies the reason for the cluster not being healthy |
| IsAttentionRequiredIsAttentionRequired | 布尔Boolean | 群集是否需要操作团队的关注If the cluster requires Operation team attention |
| AttentionRequiredReasonAttentionRequiredReason | StringString | 指定群集需要关注的原因Specifies the reason for cluster requiring attention |
| ProductVersionProductVersion | StringString | 指定产品信息（分支、版本等）Specifies product information (branch, version, and so on) |
| FailedIngestOperationsFailedIngestOperations | Int64Int64 | 前 10 分钟内引入操作失败的次数Number of failed ingestion operations in the previous 10 minutes |
| FailedMergeOperationsFailedMergeOperations | Int64Int64 | 前 1 小时内合并操作失败的次数Number of failed merge operations in the previous 1 hour |
| MaxExtentsInSingleTableMaxExtentsInSingleTable | Int64Int64 | 表中最大盘区数 (TableWithMaxExtents)Maximum number of extents in the table (TableWithMaxExtents) |
| TableWithMaxExtentsTableWithMaxExtents | StringString | 具有最大盘区数的表 (MaxExtentsInSingleTable)Table with the maximum number of extents (MaxExtentsInSingleTable) |
| WarmExtentSizeWarmExtentSize | DoubleDouble | 热缓存中盘区的总大小（以字节为单位）Total size of extents in the hot cache in bytes |
| NumberOfDatabasesNumberOfDatabases | Int32Int32 | 群集中的数据库数Number of databases in the cluster |
.show capacity.show capacity
.show capacity [with(scope = cluster | workloadgroup)]
返回每个资源的估计群集容量的计算结果。Returns the results of a calculation for an estimated cluster capacity for each resource.
scope 控制显示容量的基础。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. 如果未指定范围，则默认为 workloadgroup。If unspecified, the default scope is workloadgroup.
结果Results
| 输出参数Output parameter | 类型Type | 说明Description |
|---|---|---|
| 资源Resource | StringString | 资源的名称The name of the resource |
| 总计Total | Int64Int64 | “资源”类型的可用资源总量。The total amount of resources, of type 'Resource', that are available. 例如，并发引入数For example, the number of concurrent ingestions |
| 已耗用Consumed | Int64Int64 | 当前使用的“资源”类型的资源量The amount of resources of type 'Resource' consumed right now |
| 剩余Remaining | Int64Int64 | “资源”类型的剩余资源量The amount of remaining resources of type 'Resource' |
示例Example
| 资源Resource | 总计Total | 已耗用Consumed | 剩余Remaining |
|---|---|---|---|
| 引入ingestions | 576576 | 11 | 575575 |
.show operations.show operations
此命令返回一个表，其中包含自选择了新管理节点以来的所有管理操作。This command returns a table containing all the administrative operations since the new Admin node was elected.
| 语法选项Syntax option | 说明Description |
|---|---|
.show operations.show operations |
返回群集正在处理或已处理的所有操作Returns all operations that the cluster is processing or have processed |
.show operations OperationId.show operations OperationId |
返回特定 ID 的操作状态Returns the operation status for a specific ID |
.show operations (OperationId1, OperationId2, ...).show operations (OperationId1, OperationId2, ...) |
返回特定 ID 的操作状态Returns operations status for specific IDs |
结果Results
| 输出参数Output parameter | 类型Type | 说明Description |
|---|---|---|
| IDID | StringString | 操作标识符Operation identifier |
| 操作Operation | StringString | 管理员命令别名Admin command alias |
| NodeIdNodeId | StringString | 如果命令正在远程运行某些内容，例如 DataIngestPull。If the command is running something remotely, such as DataIngestPull. 节点 ID 将包含正在运行的远程节点的 IDThe node ID will contain the ID of the remote node that is running |
| StartedOnStartedOn | DateTimeDateTime | 操作开始的日期/时间（以 UTC 为单位）Date/time (in UTC) when the operation started |
| LastUpdatedOnLastUpdatedOn | DateTimeDateTime | 上次更新操作的日期/时间（以 UTC 为单位）。Date/time (in UTC) when the operation last updated. 该操作可以是操作中的步骤，也可以是一个完成步骤The operation can either be a step inside the operation, or a completion step |
| 持续时间Duration | DateTimeDateTime | LastUpdateOn 和 StartedOn 之间的时间跨度Time span between LastUpdateOn and StartedOn |
| 状态State | StringString | 命令状态，值可为“InProgress”、“Completed”或“Failed”Command state, with values "InProgress", "Completed", or "Failed" |
| 状态Status | StringString | 包含操作失败错误的另一个帮助字符串Additional help string that contains the errors for failed operations |
示例Example
| IDID | 操作Operation | 节点 IDNode ID | 开始日期Started On | 上次更新日期Last Updated On | 持续时间Duration | 状态State | 状态Status |
|---|---|---|---|---|---|---|---|
| 3827def6-0773-4f2a-859e-c02cf395deaf3827def6-0773-4f2a-859e-c02cf395deaf | SchemaShowSchemaShow | 2015-01-06 08:47:01.00000002015-01-06 08:47:01.0000000 | 2015-01-06 08:47:01.00000002015-01-06 08:47:01.0000000 | 0001-01-01 00:00:00.00000000001-01-01 00:00:00.0000000 | 已完成Completed | ||
| 841fafa4-076a-4cba-9300-4836da0d9c75841fafa4-076a-4cba-9300-4836da0d9c75 | DataIngestPullDataIngestPull | Kusto.Azure.Svc_IN_1Kusto.Azure.Svc_IN_1 | 2015-01-06 08:47:02.00000002015-01-06 08:47:02.0000000 | 2015-01-06 08:48:19.00000002015-01-06 08:48:19.0000000 | 0001-01-01 00:01:17.00000000001-01-01 00:01:17.0000000 | 已完成Completed | |
| e198c519-5263-4629-a158-8d68f7a1022fe198c519-5263-4629-a158-8d68f7a1022f | OperationsShowOperationsShow | 2015-01-06 08:47:18.00000002015-01-06 08:47:18.0000000 | 2015-01-06 08:47:18.00000002015-01-06 08:47:18.0000000 | 0001-01-01 00:00:00.00000000001-01-01 00:00:00.0000000 | 已完成Completed | ||
| a9f287a1-f3e6-4154-ad18-b86438da0929a9f287a1-f3e6-4154-ad18-b86438da0929 | ExtentsDropExtentsDrop | 2015-01-11 08:41:01.00000002015-01-11 08:41:01.0000000 | 0001-01-01 00:00:00.00000000001-01-01 00:00:00.0000000 | 0001-01-01 00:00:00.00000000001-01-01 00:00:00.0000000 | 正在进行InProgress | ||
| 9edb3ecc-f4b4-4738-87e1-648eed2bd9989edb3ecc-f4b4-4738-87e1-648eed2bd998 | DataIngestPullDataIngestPull | 2015-01-10 14:57:41.00000002015-01-10 14:57:41.0000000 | 2015-01-10 14:57:41.00000002015-01-10 14:57:41.0000000 | 0001-01-01 00:00:00.00000000001-01-01 00:00:00.0000000 | 已失败Failed | 集合已修改。Collection was modified. 枚举操作可能无法运行Enumeration operation may not run |