Query Conversion to Point Reads

Sai Praneeth Eranti 150

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 14,076 Reputation points Microsoft Employee

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 150 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 14,076 Reputation points Microsoft Employee

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 14,076 Reputation points Microsoft Employee

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 14,076 Reputation points Microsoft Employee

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 150 Reputation points

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

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

2 additional answers

ShaktiSingh-MSFT 14,076 Reputation points Microsoft Employee

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 150 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 14,076 Reputation points Microsoft Employee

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
Sai Praneeth Eranti 150 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