诊断信息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

返回有关 Kusto 群集运行状况的信息。Returns information about the Kusto cluster state of health.

返回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
TotalExtentSizeTotalExtentSize Int64Int64 压缩和编制索引后的存储数据的总大小Total size of the stored data, after compression and indexing
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
NumberOfDatabasesNumberOfDatabases Int32Int32 群集中的数据库数Number of databases in the cluster

.show capacity.show capacity

.show capacity

返回每个资源的估计群集容量的计算结果。Returns the results of a calculation for an estimated cluster capacity for each resource.

结果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