VCoreMongoRequests 테이블에 대한 쿼리

Mongo vCore는 작업별로 P99 기간을 요청합니다.

Mongo vCore는 작업 이름으로 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 vCore 요청

총 런타임 기간별로 범주화된 Mongo vCore 요청 수입니다.

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 vCore 요청

오류 코드별 실패한 Mongo vCore 요청 수입니다.

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 vCore 요청

사용자 에이전트의 Mongo vCore 요청 수입니다.

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