且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

专用计算机上的Azure SQL数据库与MS SQL Server

更新时间:2022-12-10 14:49:22

Microsoft可以替代Azure SQL DB:

There is an alternative from Microsoft to Azure SQL DB:

在Azure中配置SQL Server虚拟机"

"Provision a SQL Server virtual machine in Azure"

https://azure.microsoft .com/en-us/documentation/articles/virtual-machines-provision-sql-server/

详细介绍两种产品之间的区别:了解Azure VM中的Azure SQL数据库和SQL Server"

A detailed explanation of the differences between the two offerings: "Understanding Azure SQL Database and SQL Server in Azure VMs"

https://azure.microsoft.com/zh-CN/documentation/articles/data-management-azure-sql-database-and-sql-server-iaas/

独立SQL Server与Azure SQL DB之间的一个重要区别是,使用SQL DB需支付高级别的可用性,这是通过在不同的计算机上运行多个实例来实现的.这就像租用4台专用计算机并在AlwaysOn可用性组中运行它们,这将同时改变成本和性能.但是,正如您从未提到过可用性一样,我想这不是您所关心的问题. VM中的SQL Server可能会更好地满足您的需求.

One significant difference between your stand alone SQL Server and Azure SQL DB is that with SQL DB you are paying for high levels of availability, which is achieved by running multiple instances on different machines. This would be like renting 4 of your dedicated machines and running them in an AlwaysOn Availability Group, which would change both your cost and performance. However, as you never mentioned availability, I'm guessing this isn't a concern in your scenario. SQL Server in a VM may better match your needs.