Question

You are tuning a frequently executed query in a .NET application that reads from an Azure Cosmos DB for NoSQL container. Before making indexing changes, you want to accurately capture the exact RU charge consumed by each individual query execution to establish a baseline. What is the most reliable way to obtain the actual RU charge for a specific query execution?

Accepted Answer

Read the RequestCharge property from the FeedResponse returned by each iteration of the query iterator in the SDK.

Answer

Divide the container's provisioned throughput by the number of queries executed per second in Azure Monitor metrics.

Answer

Enable the integrated cache and read the cache-hit ratio from the dedicated gateway diagnostics.

Answer

Use the Total Request Units metric aggregated at the account level in Azure Monitor for the time window.