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