Edit

Share via

Queries for the VCoreMongoRequests table

  • Article

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

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/22223333-cccc-4444-dddd-5555eeee6666/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/22223333-cccc-4444-dddd-5555eeee6666/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/22223333-cccc-4444-dddd-5555eeee6666/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/22223333-cccc-4444-dddd-5555eeee6666/resourcegroups/my-resource-group-name/providers/microsoft.documentdb/mongoclusters/my-cluster-name"
| summarize count() by bin(TimeGenerated, 1h), UserAgent