Queries for the VCoreMongoRequests table
Mongo vCore requests P99 duration by operation
Mongo vCore requests P99 runtime duration by operation name.
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 requests binned by duration
Count of Mongo vCore requests binned by total runtime duration.
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)
Failed Mongo vCore requests
Count of failed Mongo vCore requests by error code.
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 requests by user agent
Count of Mongo vCore requests by user agent.
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
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for