Does SQL Server 2005 scale to a large number of databases?

If I add 3-400 databases to a single SQL Server instance will I encounter scaling issues introduced by the large number of databases?

  • How To Update A BLOB In SQL SERVER Using TSQL
  • SQL error when querying from a linked server (SQL Server linked to Oracle)
  • How do I query RDL XML data using exist and contains?
  • Finding Events During a Timeframe
  • Min/Max Subquery issue
  • Call to undefined function sqlsrv_connect() - Troubleshooting
  • Using SQL Server and mongodb with Repository pattern in node.js
  • When it's necessary to check @@trancount > 0 in try catch block?
  • How to find current transaction level?
  • Unit testing results between several stored procedures?
  • SQL Server stored procedure becomes slow after some time
  • T-SQL XOR Operator
  • 3 Solutions collect form web for “Does SQL Server 2005 scale to a large number of databases?”

    This is one of those questions best answered by: Why are you trying to do this in the first place? What is the concurrency against those databases? Are you generating databases when you could have normalized tables to do the same functionality?

    That said, yes MSSQL 2005 will handle that level of database per installation. It will more or less be what you are doing with the databases which will seriously impede your performance (incoming connections, CPU usage, etc.)

    According to Joel Spolsky in the SO podcast # 11 you will in any version up to 2005, however this is supposedly fixed in SQL Server 2005.

    You can see the transcript from the podcast here.

    I have never tried this in 2005. But a company I used to work for tried this on 7.0 and it failed miserably. With 2000 things got a lot better but querying across databases was still painfully slow and took too many system resources. I can only imagine things improved again in 2005.

    Are you querying across the databases or just hosting them on the same server? If you are querying across the databases, I think you need to take another look at your data architecture and find other ways to separate the data. If it’s just a hosting issue, you can always try it out and move off databases to other servers as capacity is reached.

    Sorry, I don’t have a definite answer here.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.