I was recently reading on the subject SQL Azure Throttling and Decoding Reason Codes and end up reading the article over here. What I really liked is the explanation of the subject with Graphic. I have never seen any better explanation of this subject.
I really liked this diagram. However, based on reason code one has to adjust their resource usages. I now wonder do we have any tool available which can directly analysis the reason codes and based on it gives output that what kind of the throttling is happening. One of the idea I immediately got that I can make a Stored Procedure or Function where I pass this error code and it gives me back right away the throttling mode and resource type based on above algorithm.
Any one has the T-SQL code available for the same?
Reference: Pinal Dave (https://blog.sqlauthority.com)
4 Comments. Leave new
Here is the example that you are looking for:
https://social.technet.microsoft.com/wiki/contents/articles/3507.microsoft-azure-sql-database-performance-and-elasticity-guide.aspx#Code_Sample_Decoding_SQL_Azure_Reason_Codes
This article is a great one. It describes all clearly. I really liked it. It’s very helpful. I was looking for such articles. I have read a article here “http://www.techyv.com/article/sql-azure-decoded” which is almost like this.
Yes, I must say that this diagram is really helpful in understanding SQL Azure. Thank you very much for sharing this with us. I really appreciate that. To find out more on SQL Azure decoding, check out the following article:
It is a very helpful article and the writer has set out each and every thing step-by-step.
How can we create a throttling exception easily.( to test the TransientFaultHandling libraries in windows azure.)