0

Having possibly several thousands customers I want to create one DB for each client where I will hold a small sized number of tables and records (from 5000 to less than 100,000 records per DB).

Is there a limitation with SQL Server 2012 or 2014 Express with regard to the maximum number of DBs?

Will this affect the overall performance of the server?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
user3553401
  • 109
  • 2
  • 15
  • 1
    The maximum number or databases is `32767` and the Maximum size of a database is 10GB for both SQL Server 2012 and 2014, [`Maximum Capacity Specifications for SQL Server`](https://msdn.microsoft.com/en-us/library/ms143432%28v=sql.110%29.aspx) – M.Ali Feb 21 '15 at 15:11
  • This may be of interest: http://stackoverflow.com/questions/1169634/limitations-of-sql-server-express – Elliveny Feb 21 '15 at 15:11
  • It is technically possible to use Express but you might not be able to get adequate performance with many concurrent clients if the database is used heavily. Performance may be adequate with fewer concurrent clients and/or the queries are trivial. – Dan Guzman Feb 21 '15 at 15:35

0 Answers0