Windows Azure Benchmarks–Part 13: Sql Azure Read throughput

One of the most common questions customers ask is how does windows azure perform.
Well Microsoft published a series of benchmarks in an excellent web site called azurescope.
The thing is azurescope is going down on January 15th 2012 so I decided to publish these benchmarks here and make sure they will be available to the public.

Let us discuss Sql Azure read throughput.

This test measures the ability of SQL Azure to handle read requests from simultaneous clients.

Key Analysis

• Throughput increases with the increase in number of concurrent clients (NumberOfWorkers * ThreadsPerWorker) and saturates at a maximum value.
• Bigger batch size improves throughput.
• Smaller row size improves throughput.
• Employing more than one thread per worker improves throughput.

Enjoy

Manu