SQL Azure – SQL Azure Throttling and Decoding Reason Codes

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.

SQL Azure - SQL Azure Throttling and Decoding Reason Codes DecodingCode

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)

Previous Post
SQL SERVER – A Quick Notes on SQL Azure
Next Post
SQL SERVER – Puzzle – SELECT * vs SELECT COUNT(*)

Related Posts

4 Comments. Leave new

Leave a Reply

Menu