問題描述
在其中一個 stackoverflow 播客(我認為是 #18)中，Jeff 和 Joel 正在談論多租戶數據庫與單租戶數據庫.Joel 提到FogBugz on Demand"針對每個客戶架構使用了一個數據庫，我想知道是否還有一個點需要多個數據庫服務器來分配負載?
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?
推薦答案
從技術上講，SQL Server 中每個實例的數據庫數限制是 32,767，但我懷疑您是否可以使用具有 2,000 個以上數據庫的 SQL Server 實例，那時點服務器可能沒有響應.
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.
如果所有數據庫都自動關閉且未被使用，您可能擁有近 30,000 個數據庫.您可以在此處找到有關容量限制的更多信息:
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:
SQL Server 的最大容量規范
這篇關于SQL Server 中數據庫數量的實際限制?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！