![]() ![]() In my opinion, if you are building a new PaaS solution based on SQL Server, your best approach is to run on Azure SQL DB. While AWS is a big customer, and will be quick to roll out new updates and versions, they are still subject to Microsoft’s external release cycle whereas Azure is not. There will always be an inherent feature advantage to being on Azure SQL DB over AWS RDS, as Microsoft owns the code and can roll it out faster. You can argue that this isn’t fair, but it’s Microsoft’s ball game, so they get to make the rules. This is a big advantage that Microsoft has over Amazon is that they control the licensing for SQL Server. (Which you can know pay for on a month to month basis). Where the real benefits come in, are that Microsoft allows you to bring on-premises licenses to Azure SQL Database, and the fact the Microsoft offers a much lower cost for 3 year reservations. If you use use the elastic pool functionality in Azure SQL DB which is the same cost as single database SQL DB, you get a better comparison. Azure is $25,000/month less, however it’s not quite an apples to apples comparison, as Azure SQL DB is single database service as opposed to RDS which acts more like Managed Instance, or on-premises SQL Server. In terms of raw pricing, there is a significant difference between Azure SQL DB and AWS pricing for these two instances. For information about Multi-AZ DB cluster read replicas, see Working with Multi-AZ DB cluster read replicas. In the raw performance numbers, SQL DB was a little bit better in terms of overall throughput, but where Azure really shines in comparison to AWS is pricing. Monitoring read replication Creating a read replica in a different AWS Region Overview of Amazon RDS read replicas The following sections discuss DB instance read replicas. ![]() GigaOm derived from the TPC-E workload, which is a blended OLTP workload which involves both read-only and update transactions. However, GigaOm was able to build a test case where they used similar sized offerings as shown in the image below. One of the many challenges of this kind of a study is that the product offerings are not exactly analogous. It’s an interesting test case that tries to compare the performance of these platform as a service database offerings. Yesterday, GigaOm published a benchmark of Azure SQL Database as compared to Amazon’s RDS service. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |