SQL Server中数据库的实际限制？ [英] Practical limit for the number of databases in SQL Server?

问题描述

在其中一个stackoverflow播客（＃18我认为）Jeff和Joel正在谈论多对单一租户数据库。 Joel提到FogBugz on Demand使用了每个客户架构的数据库，我想知道是否有一个要点，您需要多个数据库服务器来分配负载？

解决方案

从技术上讲，SQL Server中每个实例的数据库限制为32,767，但我怀疑您可以使用具有超过2000个数据库的SQL Server实例，那时服务器可能不会响应。

如果全部自动关闭并且未被使用，您可能拥有近30,000个数据库。您可以在这里找到有关容量限制的更多信息：

SQL Server的最大容量规格

In one of the stackoverflow podcasts (#18 I think) Jeff and Joel were talking about multi vs single tenant databases. Joel mentioned that "FogBugz on Demand" used a database per customer architecture and I was wondering if there is a point beyond which you'll need to have multiple database servers to distribute the load?

解决方案

Technically the limit of databases per instance in SQL Server is 32,767, but I doubt that you could use a SQL Server instance that has more than 2,000 databases, at that point the server would probably be not responsive.

You may be able to have close to 30,000 databases if they were all auto-closed and not being used. you can find more information about capacity limits here:

Maximum Capacity Specifications for SQL Server

这篇关于SQL Server中数据库的实际限制？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！