SQL Azure-单独的服务器? [英] Sql Azure - separate servers?

问题描述

让我说我既不是数据库专家也不是Azure专家来开头这个问题.

Let me preface this question by saying I'm neither a database nor Azure expert.

看来，MS通过Sql Azure数据库的大小和数量而不是通过服务器数量来收费.因此，从成本角度来看，在每个服务器实例上放置一个数据库是可行的.我的理解是，有时候将数据库放在单独的物理服务器上比在高使用场景下将其放在一台计算机上更为有益.是否/将同样的方法应用于Sql Azure虚拟服务器?这是我可以找到的有关SQL Azure服务器实例的信息:

It appears that MS charges by the size and number of Sql Azure dbases and not by the number of servers. Thus, cost-wise it seems feasible to put a single dbase on each server instance. My understanding is that sometimes it's more beneficial to put databases on separate, physical servers rather than on one machine in high use scenarios. Would/could the same be applied to Sql Azure virtual servers? Here's what I could find about Sql Azure server instances:

SQL Azure服务器是数据库的逻辑组，并充当多个数据库的中央管理点.每个SQL Azure服务器都包含与您所在场所的SQL Server实例类似的登录名."(我还要补充一点，尽管所有数据库都将由相同的Web角色访问和使用，但是没有一个数据库会直接需要彼此的数据.

Let me also add that though all of the databases will be accessed and used by the same Web Roles, none of the databases will require data from each other, directly.

推荐答案

数据库的物理位置和服务器的数量绝对彼此无关.如果您有10个服务器和10个数据库，或者1个服务器和10个数据库，则是相同的.最后，您将拥有10个数据库，这些数据库物理上位于您绝对无法控制的分布中的云的各个部分.它们可能全部是10个(在同一个物理主机上)(或者每个都在一个单独的主机上(可能性更大))，您将无法控制，也无法真正发现.

The physical location of your database and the number of servers have absolutely nothing to do which each other. Wether you have 10 servers and 10 databases or 1 server and 10 databases, it is the same. In the end you will have 10 databases, located physically on various parts of the cloud in a distribution that you absolutely have no control over. They may be all 10 on the same physical host (unlikely), or each one on a separate host (much more likely), you won't be able to control nor will you be able to actually find out.

这篇关于SQL Azure-单独的服务器?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！