How to find the runing query in azure cosmos

Sachin Agarwal 1

I am using Azure Cosmos and observed that RU is 100% utilized continue so I just wanted to know the running query in cosmos because I am nt running anything but still its showing 100 % RU Utilized ..

RU configure 500
Type : Autoscale.

GeethaThatipatri-MSFT 27,017 Reputation points Microsoft Employee

2022-01-25T14:35:51.107+00:00

Hi, @Sachin Agarwal Welcome to Microsoft Q&A, Thanks for posting your question.
Can you please check in Azure activity under logs for 30 days and see what all the requests are?

Regards
Geetha
Sachin Agarwal 1 Reputation point

2022-01-25T15:30:03.343+00:00

I checked its showing 0 result but still cosmos RU is 100 % maintained ..@GeethaThatipatri-MSFT
GeethaThatipatri-MSFT 27,017 Reputation points Microsoft Employee

2022-01-25T16:15:15.253+00:00

Thanks, @Sachin Agarwal for checking, RU consumption there can be many reasons I would recommend checking this document which might help you Request Units as a throughput and performance currency in Azure Cosmos DB | Microsoft Learn

Regards
Geetha
Sachin Agarwal 1 Reputation point

2022-01-25T16:28:30.593+00:00

Thanks I have gone through this but I did not understand till now that it never happen before but only from today onwards I can see RU is max utilized 100 % continuously and I am not running anything so just looking for the query which is running in my cosmos which can tell me what's going on .@GeethaThatipatri-MSFT
Sachin Agarwal 1 Reputation point

2022-01-25T16:39:05.41+00:00

Error I can see all time now is :

Failure in submitting query. Server error: ActivityId : f24fe655-f90a-4ab0-aecd-ef3f1569f4f4 ExceptionType : RequestRateTooLargeException ExceptionMessage : Message: {"Errors":["Request rate is large. More Request Units may be needed, so no changes were made. Please retry this request later. Learn more: http://aka.ms/cosmosdb-error-429"]}
GeethaThatipatri-MSFT 27,017 Reputation points Microsoft Employee

2022-01-26T22:59:34.137+00:00

@Sachin Agarwal I am checking with the internal team and provide you with more details.

Regards
Geetha
GeethaThatipatri-MSFT 27,017 Reputation points Microsoft Employee

2022-01-28T18:31:12.477+00:00

Hi @Sachin Agarwal , as per the internal team you need to reach out to the support team for deeper investigation. if you have a support plan you may file a support ticket else, we can create a one-time-free support ticket for you to work closely on this.

Regards
Geetha