Azure also provides a PaaS-environment for SQL databases. In my effort to get familiar with them, I also ran a benchmark between all editions, which I wanted to share with you. So today we will run a benchmark versus each database edition to see how they will cope!
- Specs : Azure Basic A3 (4 cores, 7 GB memory)
- Software : Database Benchmark + SQL Mgmt Studio
- Network : Internal Virtual Network + Public Internet Connectivity
- Basic Edition – “BASIC-B0” – 5 DTU
- Standard Edition S0 – “STD-S0” – 10 DTU
- Standard Edition S1 – “STD-S1” – 20 DTU
- Standard Edition S2 – “STD-S2” – 50 DTU
- Standard Edition S3 – “STD-S3” – 100 DTU
- Premium Edition P1 – “PREMIUM-P1” – 100 DTU
- Premium Edition P2 – “PREMIUM-P2” – 200 DTU
- Premium Edition P3 – “PREMIUM-P3” – 800 DTU
- All the test were run sequentially
- 5 tables of 10.000 records were used as test environment
- The SQL2012 benchmark was used. (so not the compact one)
And now on to the results…
A difference is visible between all database editions, except the “premium”-edition looks to to be on par with eachother. At this time I cannot judge to the cause of this, where I’m assuming the test system or test method reached a limit (to be updated!).
And what can I do with it?
You can now run the benchmarks on your own systems and see how they compare… It will provide you with an insight that will render you capable of comparing performance beforehand in regards to a possible implementation.
Once considering the Azure Databases, be ware that you are limited to SQL authentication. Many enterprises have integrated their SQL rights management in Active Directory, which is not possible with the current implementation of Azure.