Monday, November 10, 2014

Azure SQL Database Service Tiers and Performance Levels


Even basic supports 5 transactions per second based on Microsoft internal benchmarking. I guess we should cut the value in half for real world performance. But i would think that most web sites could run well on the Basic plan.

Plan
 DTU
 Benchmark
 Rating
 Per Hour
 Per Minute
 Per Second
 Basic
 5.0
 16,600 transactions per hour
 Good
 16,600
 277
 5
 Standard/S0
 10.0
 521 transactions per minute
 Better
 31,260
 521
 9
 Standard/S1
 20.0
 934 transactions per minute
 Better
 56,040
 934
 16
 Standard/S2
 50.0
 2,570 transactions per minute
 Better
 154,200
 2,570
 43
 Premium/P1
 100.0
 105 transactions per second
 Best
 378,000
 6,300
 105
 Premium/P2
 200.0
 228 transactions per second
 Best
 820,800
 13,680
 228
 Premium/P3
 800.0
 735 transactions per second
 Best
 2,646,000
 44,100
 735
http://msdn.microsoft.com/library/azure/dn741336.aspx

No comments:

Post a Comment