VCoreMongoRequests 數據表的查詢

如需在 Azure 入口網站 使用這些查詢的詳細資訊，請參閱Log Analytics教學課程。 如需 REST API，請參閱 查詢。

Mongo 虛擬核心依作業要求 P99 持續時間

Mongo 虛擬核心會依作業名稱要求 P99 運行時間持續時間。

VCoreMongoRequests
// Time range filter:  | where TimeGenerated between (StartTime .. EndTime)
// Resource id filter: | where _ResourceId == "/subscriptions/00000000-0000-0000-0000-000000000000/resourcegroups/my-resource-group-name/providers/microsoft.documentdb/mongoclusters/my-cluster-name"
| summarize percentile(DurationMs, 99) by bin(TimeGenerated, 1h), OperationName

依持續時間量化的 Mongo 虛擬核心要求

依運行時間總持續時間量化的 Mongo 虛擬核心要求計數。

VCoreMongoRequests
// Time range filter:  | where TimeGenerated between (StartTime .. EndTime)
// Resource id filter: | where _ResourceId == "/subscriptions/00000000-0000-0000-0000-000000000000/resourcegroups/my-resource-group-name/providers/microsoft.documentdb/mongoclusters/my-cluster-name"
| project TimeGenerated, DurationBin=tostring(bin(DurationMs, 5))
| summarize count() by bin(TimeGenerated, 1m), tostring(DurationBin)

失敗的 Mongo 虛擬核心要求

依錯誤碼計算失敗的 Mongo 虛擬核心要求計數。

VCoreMongoRequests
// Time range filter:  | where TimeGenerated between (StartTime .. EndTime)
// Resource id filter: | where _ResourceId == "/subscriptions/00000000-0000-0000-0000-000000000000/resourcegroups/my-resource-group-name/providers/microsoft.documentdb/mongoclusters/my-cluster-name"
| where ErrorCode != 0
| summarize count() by bin(TimeGenerated, 5m), ErrorCode=tostring(ErrorCode)

依使用者代理程式提出的 Mongo 虛擬核心要求

使用者代理程式的 Mongo 虛擬核心要求計數。

VCoreMongoRequests
// Time range filter:  | where TimeGenerated between (StartTime .. EndTime)
// Resource id filter: | where _ResourceId == "/subscriptions/00000000-0000-0000-0000-000000000000/resourcegroups/my-resource-group-name/providers/microsoft.documentdb/mongoclusters/my-cluster-name"
| summarize count() by bin(TimeGenerated, 1h), UserAgent