SQL Server的数据库限制的单个实例 [英] Single instance of SQL server's database limit
问题描述
我将在ASP.NET中使用SQL Server发布一个webproject。但我的客户有很多分支机构（全国数千家商店）。我的客户要求是通过多态来部署项目。这意味着每个客户都有自己的网站，其中包含唯一的子域和唯一的数据库（这些将自动生成）。每个商店都有几乎1 GB的数据存储在数据库中。现在我的问题是
1.在单个SQL Server实例中可以创建多少个数据库（这意味着有多少商店可以在数据库中存储数据）。如果他们的数据在未来增加，我可以选择哪种策略。
2.还建议我哪个托管公司最适合ASP.NET& SQL Server项目及其提供的范围
3.还告诉我哪种SQL Server版本最适合这种情况
我尝试了什么：
直到我只有项目并且想要部署。
可以创建多少个数据库在单个SQL Server实例中？
I'm going to publish a webproject in ASP.NET with SQL Server. But there are so many branches of my client (thousands of shops over country). my client's requirement is to deploy the project through polymorphism. that mean every client have its own website with a unique subdomain and unique database (those will generated automatically). each shop has almost upto 1 GB data for storing in database. now my question is that
1. how many databases can be created in single instance of SQL Server (that mean how many shop can be store there data in database). and which strategy i can choose if their data increase in future.
2. Also suggest me which hosting company is best for ASP.NET & SQL Server Projects and what they offer with their range
3. Also tell me which SQL Server edition is best in such condition
What I have tried:
Till i have only project and want to deploy.
how many databases can be created in a single instance of SQL Server?
推荐答案
它可能取决于SQL Server的版本，但理论上，每个实例可以有32,767个数据库： SQL Server的最大容量规格 [ ^ ]
但......其余的基础设施是否会支持这么多请求？我认为你需要密切关注你期望产生的整个可能的流量，并做出相应的计划。我不会尝试将那么多数据库放在一个SQL服务器实例上，即使它是一个主要的服务器场！
It probably depends on the version of SQL Server, but in theory, you could have 32,767 databases per instance: Maximum Capacity Specifications for SQL Server[^]
But...would the rest of the infrastructure support that many requests? I think you'd need to look closely at the whole "probably traffic" you expect to be generated, and plan accordingly. I wouldn't try putting that many DBs on a single SQL server instance, even if it was a major server farm!
这篇关于SQL Server的数据库限制的单个实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
