Query Conversion to Point Reads

Sai Praneeth Eranti 170

Hello ,

Is there a way to identify eligible queries that can be transformed into point read queries using metrics or a Kusto query?

ShaktiSingh-MSFT 15,841 Reputation points

2024-05-14T14:24:41.1833333+00:00

Hi Sai Praneeth Eranti •,

Welcome to Microsoft Q&A forum.

As I understand, is there a way to identify eligible queries that can be transformed into point read queries using metrics or a Kusto query.

Please refer to the section

Transforming queries to point reads

here:

https://devblogs.microsoft.com/cosmosdb/point-reads-versus-queries/

if that helps.

Thanks
Sai Praneeth Eranti 170 Reputation points

2024-05-14T15:04:31.9166667+00:00

Hi @ShaktiSingh-MSFT ,

This link explains how the feature works . But , I'm looking to see if metric or Kusto queries are available to check if a given query is eligible to convert point reads instead checking manually.

In brief : Suppose for a given existing prod system 1000 queries are running daily to fetch data . Now , My requirement is to analyse if any queries are eligible to convert point reads . Is there a way that I can analyse 1000 queries and filter through automated process ?
ShaktiSingh-MSFT 15,841 Reputation points

2024-05-15T03:59:44.1366667+00:00

Hi Sai Praneeth Eranti •,

Thanks for the details.

Let me check and get back to you.

Accepted answer

ShaktiSingh-MSFT 15,841 Reputation points

2024-05-20T05:40:40.97+00:00

Hi Sai Praneeth Eranti •,

Below is the reply received internally:

I think you can enable the clear query text in CDBDataPlaneRequests? If so, filtering for queries where the query text contains ".id" and the document count returns is always 0 or 1 is probably be a good way to filter to those queries worth double-checking.

Thanks
Please sign in to rate this answer.
ShaktiSingh-MSFT 15,841 Reputation points

2024-05-22T03:46:22.3666667+00:00

Hi Sai Praneeth Eranti •,

I would recommend you to please file a support ticket for deeper look into the question for which reference would be used and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you.

Thanks

Sai Praneeth Eranti 170 Reputation points

2024-05-22T05:11:35.2166667+00:00

Sure @ShaktiSingh-MSFT . Thankyou .
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

2 additional answers

ShaktiSingh-MSFT 15,841 Reputation points

2024-05-15T08:59:04.1266667+00:00

Hi Sai Praneeth Eranti •,

Thanks for your patience.

I have checked with the internal team and has got below reply:

It can be identified via data plane requests:

Azure Monitor Logs reference - CDBDataPlaneRequests | Microsoft Learn

by checking OperationName and RequestResourceType.

Thanks
Please sign in to rate this answer.
Sai Praneeth Eranti 170 Reputation points

2024-05-15T11:33:48.5366667+00:00

Hi @ShaktiSingh-MSFT ,

It just says whether it is a read query or non-read query but it doesn't say whether it is eligible for conversion . I'm looking to see if any kusto or metric says it instead i do check manually and confirm if it can be converted to point read .

I'm just trying to see if we have option like that else will proceed manually .

ShaktiSingh-MSFT 15,841 Reputation points

2024-05-16T04:46:11.7366667+00:00

Hi Sai Praneeth Eranti •,

I am checking with the team, thanks for your patience.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Sai Praneeth Eranti 170 Reputation points

2024-05-21T09:25:42.1966667+00:00

Hi @ShaktiSingh-MSFT

In "CDBDataPlaneRequests" , there is no column which gives query text . I think it should be "CDBQueryRuntimeStatistics".
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Query Conversion to Point Reads

2 additional answers

Your answer