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.

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 (http://blog.SQLAuthority.com)

About these ads

4 thoughts on “SQL Azure – SQL Azure Throttling and Decoding Reason Codes

  1. 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.

  2. 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: http://www.techyv.com/article/sql-azure-decoded
    It is a very helpful article and the writer has set out each and every thing step-by-step.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s