How to control Priority-based executions in Azure Cosmos DB

Sai Praneeth Eranti 125

Hi Team ,

I would like to know , How I can leverage this feature in a better way . Suppose , RU consumption is 100% if I want to do a transaction , How can I make it a priority ? Should I specify priority "high" at the time of querying like shown in the example ? How can I make the transactions which are coming from APPs to run as high priority where we can't ask users to specify priority level ? Also , Is there a way that I can make all read transactions low and write transactions high from the DBA stand point where we get queries from APPs and not controlled from our end ?

//Display product information to user with high priority
RequestOptions getProductRequestOptions = new ItemRequestOptions{PriorityLevel = PriorityLevel.High};

GeethaThatipatri-MSFT 27,887 Reputation points Microsoft Employee

2024-01-23T18:58:30.87+00:00

Hi, @Sai Praneeth Eranti Thanks for posting your question in the Microsoft Q&A forum.

You can set the priority level for a transaction by using the RequestOptions object in the Azure Cosmos DB SDK. The RequestOptions object allows you to set various options for a request, including the priority level. If you want to make all read transactions low and write transactions high from the DBA standpoint, you can use the Azure Cosmos DB REST API to set the default consistency level.

However, I will check with internal product team and provide you with more information.

https://learn.microsoft.com/en-us/azure/cosmos-db/consistency-levels

Regards

Geetha
Sai Praneeth Eranti 125 Reputation points

2024-01-24T09:26:37.91+00:00

Hi @GeethaThatipatri-MSFT ,

Thanks for the Update , Please keep me posted . How consistency levels are being used for priority based execution . Could you please provide more info ?

Accepted answer

Richa Gaur 75 Reputation points Microsoft Employee

2024-01-25T09:16:33.2933333+00:00

Hi @Sai Praneeth Eranti, Thanks for posting your question.

We would like to help you onboard to Priority-based execution and understand more about your use-case where you need to set priorities for different clients from DBA standpoint. Would you be interested in a short discussion with the product team at Microsoft?

If yes, please share your contact details in this form: https://forms.microsoft.com/r/Gq6Wjv7Mmc
Please sign in to rate this answer.
Sai Praneeth Eranti 125 Reputation points

2024-01-25T10:30:30.25+00:00

@Richa Gaur I have submitted the form .

Sai Praneeth Eranti 125 Reputation points

2024-04-30T08:27:06.9266667+00:00

@Richa Gaur @Richa Gaur Could you please provide more details on limitations given in this article? I did testing by enabling this feature but it is not working as expected . Could you please help us when does it work and when it doesn't?

Steps I have performed during testing :

Enabled the preview Feature

Made container to throttled

Ran the query from Data Explorer by setting the priority level "High"

But the query was timed-out due to insufficient RU's.

Richa Gaur 75 Reputation points Microsoft Employee

2024-04-30T09:26:07.4766667+00:00

The feature basically throttles low priority requests first if the container is running at capacity. If high priority requests volume itself is more than 100% then both high and low priority would be throttled.

In your scenario, I don't see any low priority request being sent to the container. Also since the volume of high priority request itself is 100% then new requests won't be accepted.

To understand more about how to test the feature, please go through: https://devblogs.microsoft.com/cosmosdb/introducing-priority-based-execution-in-azure-cosmos-db-preview/

Sai Praneeth Eranti 125 Reputation points

2024-04-30T09:45:48.0366667+00:00

@Richa Gaur Thankyou . One last thing ,

Is changing the priority level using CLI and Data Explorer the same ? or is it like changing the priority level using CLI is account level and scope of data explorer is to itself ?

az cosmosdb update --resource-group $ResourceGroup --name $AccountName --default-priority-level low
Sign in to comment

Share via

How to control Priority-based executions in Azure Cosmos DB

0 additional answers