Determine query cost in Gremlin.NET on Comos DB

I found it hard to find the query cost when using Gremlin.NET on Cosmos DB.

The only way I found until now is to analyse the exception text when a RequestRateTooLargeException is thrown.

Typically the most resource intensive queries throw these exceptions so it is interesting to analyse the query costs for these specific queries.

ServerError:
ActivityId : 3ae242d9-09bd-4870-8e0c-5f3b56941726
ExceptionType : RequestRateTooLargeException
ExceptionMessage :
 Message: {"Errors":["Request rate is large"]}
 ActivityId: 3f4d0f5c-a776-4f41-ab9c-ee9f08d64ca4, Request URI:, RequestStats:
 ResponseTime: 2018-03-26T06:57:58.4519869Z, StoreReadResult: StorePhysicalAddress: , GlobalCommittedLsn: 7393074, PartitionKeyRangeId: , IsValid: True, StatusCode: 0, IsGone: False, IsNotFound: False, IsInvalidPartition: False, RequestCharge: 0.38, ItemLSN: -1, ResourceType: Document, OperationType: Query
 , SDK: documentdb-dotnet-sdk/1.20.0 Host/64-bit MicrosoftWindowsNT/6.2.9200.0
Source : Microsoft.Azure.Documents.ClientMessage: {"Errors":["Request rate is large"]}
ActivityId: 3f4d0f5c-a776-4f41-ab9c-ee9f08d64ca4, Request URI: /, RequestStats:
ResponseTime: 2018-03-26T06:57:58.4519869Z, StoreReadResult: StorePhysicalAddress: , LSN: 7393075, GlobalCommittedLsn: 7393074, PartitionKeyRangeId: , IsValid: True, StatusCode: 0, IsGone: False, IsNotFound: False, IsInvalidPartition: False, RequestCharge: 0.38, ItemLSN: -1, ResourceType: Document, OperationType: Query
, SDK: documentdb-dotnet-sdk/1.20.0 Host/64-bit MicrosoftWindowsNT/6.2.9200.0
 BackendStatusCode : 429
 BackendActivityId : 3f4d0f5c-a776-4f41-ab9c-ee9f08d64ca4
 HResult : 0x80131500

I get the request charge out of the exception in the following way

   try
               {
                    var results = await _gremlinClient.SubmitAsync(query);
                    
                    return results;
                }
                catch (ResponseException r)
                {
                    if (r.Message.Contains("Request rate is large"))
                    {
                        Regex queryCostFinder = new Regex(@"RequestCharge: (\d{1,5}\.\d{1,4})");
                        var match = queryCostFinder.Match(r.Message);
                        queryCosts = double.Parse(match.Groups[1].Value);
                    }
                    else
                        throw;
                }







It helps but you rather see a property in Gremlin.NET that returns this value from the Http request charge header so you know it for all requests. I did not find a solution yet to fetch this header by using Gremlin.NET

Comments

Post a Comment

Popular posts from this blog

System.Net.Http dll version problems

Last few weeks we had problems with referencing the correct System.Net.Http version. This is probably because some components use internally higher versions (.NET Core with System.Net.Http 4.2.0.0) compared to the versions that are available in NuGet. Frequently we got errors like: Could not load file or assembly 'System.Net.Http, Version=4.1.1.2, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) What is the solution.... That is a great questions. But we do not have the satisfying answer yet. What we currently do is the following. - Use in all projects the same System.Net.Http version, currently we use v4.3.3 from nugget - Compile the code and check in the resulting Bin folder what the resulting System.Net.Http version is - Use this version as BindingRedirect in the app.config / web.config like <dependentAssembly>
Read more

SharePoint Survey Back Button

On Internet I could not find a correct solution for implementing a back button in a survey. After some search I found some near implementations but not an implementation that fully worked. One that inspired me was http://sharepointbender.blogspot.nl/2012/04/creating-back-button-on-sharepoint-2010.html but I found the history.back(-2) not satisfying. I wrote my one version in Javascript that uses the FirstField parameter of the survey to implement a correct behaviour. I hope it makes you happy. In the edit form I added a script link to the code below and i added the following statement spbackButton.init("Name of list"); In an javascript file I included the following code. var spbackButton = (function () { var _prevFieldsArray = new Array(); var _currentStep; var _prevPageStep; function setCookie(c_name,value,exdays) { var exdate=new Date(); exdate.setDate(exdate.getDate() + exdays); var c
Read more

How to set up AD FS for a development machine

Image
In this article I will describe how you should set up a development computer to use an existing AD FS. First thing we need to do is to create a trust between the ADFS server and the development machine. You can do this by login in with RDP at the server that is running ADFS and start up the "AD FS 2.0 Management" that is found under the Administrative tools. When the AD FS 2.0 Management studio is started you need to navigate to the "Relying Party Trusts" in the left folder structure. Then you nee to select "Add Relying Party Trust..." in the right menu. This will open the "Add Relying Party Trust Wizard" as shown below. When clicked on "Start" the following screen will open. Here you can specify how the relying party configuration is configured. For a development machine it is most easy to select just the last option "Enter data about the relying party manually" In the next screen you can fill in a name and descr
Read more