关于通过Log Analytics查询Synapse Analytics Notebook使用指标的技术咨询

是的，Log Analytics中存在专门的内置表SynapseNotebookLogs，可用于获取Synapse Analytics Notebook的各类执行指标，该表记录了Notebook执行的用户信息、时长、状态、执行ID等关键数据。

常用KQL查询示例 #

1. 统计执行Notebook次数最多的用户 #

SynapseNotebookLogs
| where OperationName == "ExecuteNotebook"
| summarize ExecutionCount = count() by UserId
| sort by ExecutionCount desc
| take 10

2. 统计各Notebook的平均/总执行时长 #

SynapseNotebookLogs
| where OperationName == "ExecuteNotebook" and Status == "Succeeded"
| extend ExecutionDurationMs = tolong(DurationMs)
| summarize 
    AvgDurationMs = avg(ExecutionDurationMs),
    TotalDurationMs = sum(ExecutionDurationMs),
    ExecutionCount = count()
    by NotebookName = tostring(Properties.NotebookName)
| sort by AvgDurationMs desc

3. 按用户统计Notebook执行的成功/失败占比 #

SynapseNotebookLogs
| where OperationName == "ExecuteNotebook"
| summarize 
    TotalExecutions = count(),
    SuccessCount = countif(Status == "Succeeded"),
    FailureCount = countif(Status == "Failed")
    by UserId
| extend SuccessRate = round(SuccessCount * 100.0 / TotalExecutions, 2)
| sort by TotalExecutions desc

4. 查看单个Notebook的所有执行详情 #

SynapseNotebookLogs
| where OperationName == "ExecuteNotebook" and tostring(Properties.NotebookName) == "YourNotebookName"
| project 
    ExecutionTime = TimeGenerated,
    UserId,
    Status,
    DurationMs,
    ExecutionId = tostring(Properties.ExecutionId)
| sort by ExecutionTime desc

注：部分字段可能需要根据你的Synapse环境配置调整，比如Properties中的子字段，可通过SynapseNotebookLogs | project *查看表的完整字段结构。

内容的提问来源于stack exchange，提问作者Prakash