Scenario 5 – Request throttling problems and HTTP 403 – Forbidden issues

Referring to my blog on Azure API Management Troubleshooting Series, this is the fifth scenario of the lab. Please make sure you have followed the lab setup instructions as per this, to recreate the problem.   Symptom The ‘Resources’ API fetches user’s personal details, social media posts, comments and photos and utilizes the response returned…


Scenario 4 – Performance hit in API calls

Referring to my blog on Azure API Management Troubleshooting Series, this is the fourth scenario of the lab. Please make sure you have followed the lab setup instructions as per this, to recreate the problem.   Symptom The API ‘ProductStore’ in APIM communicates with the backend endpoint (https://productstoreapp.azurewebsites.net) to easily create, read, update and delete…


Scenario 3 – Receiving unauthorized errors (401) while invoking APIs

Referring to my blog on Azure API Management Troubleshooting Series, this is the third scenario of the lab. Please make sure you have followed the lab setup instructions as per this, to recreate the problem.   Symptom The ‘Echo API’ suddenly started throwing diverse types of HTTP 401 – Unauthorized errors while invoking the operations…


Scenario 2 – SOAP based API returning 404 and 500 HTTP status codes

Referring to my blog on Azure API Management Troubleshooting Series, this is the second scenario of the lab. Please make sure you have followed the lab setup instructions as per this, to recreate the problem.   Symptom The Calculator API can perform four operations – Add, Subtract, Multiply and Divide based upon two input parameters…


Azure API Management Troubleshooting Series

Hello Azure folks… I was thinking of developing a troubleshooting series on Azure API Management for a long time… finally I was able to spare some time and developed some of the scenarios which would be helpful for the folks having intermediate experience in APIM. To troubleshoot these issues, you need to have some basic…


Scenario 1 – API returning blank response

Referring to my blog on Azure API Management Troubleshooting Series, this is the first scenario of the lab. Please make sure you have followed the lab setup instructions as per this, to recreate the problem.   Symptom The API ‘Blank API’ consists of two operations ‘GetHeaders’ and ‘GetMyIp’. GetMyIp returns the value of X-FORWARDED-FOR header…


workaround for SQLNexus fail to import SQL 2016 trc file(SQLNexus ReadTrace匯入sql 2016 trc失敗)

workaround for SQLNexus fail to import SQL 2016 trc file(SQLNexus ReadTrace匯入sql 2016 trc失敗) Problem: Readtrace (SQL Profiler TRC Files) Import failed. Analysis: from ReadTrace.log 07/23/18 00:32:50.485 [0X00001364] The major version number (13) in the trace file header is not a supported file version. 07/23/18 00:32:50.485 [0X00001364] ERROR: Read of file header for file C:Temp20180712110000SQLSERVER-1_SQLDIAG__sp_trace.trc failed…


Storage performance best practices and considerations for Azure SQL DB Managed Instance (General Purpose)

Reviewed by: Kun Cheng, Borko Novakovic, Jovan Popovic, Denzil Ribeiro, Rajesh Setlem, Arvind Shyamsundar, Branislav Uzelac In this article, we describe database storage architecture on Azure SQL Database Managed Instance (MI), for General Purpose (GP) instances specifically. We also provide a set of best practices to help optimize storage performance. At the time of this…


Demand Forecasting: Performance influencers

In this blog post we will explain the key performance influences for the Demand Forecasting feature for Microsoft Dynamics 365 for Finance & Operations, which are under the user’s control. It is important to read and understand this blog if you are implementing Demand Forecasting for Microsoft Dynamics 365 for Finance & Operations or if you…


Product Configuration: Performance with Z3

Introduction In the spring release of 2018 for Microsoft Dynamics 365 for Finance & Operations a significant investment in improving performance of the constraint evaluation has been made. The result of this investment is the introduction of the Z3 sovler strategy. Z3 is a theorem prover from Microsoft Research, that has won several awards and has…