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?

  • Reference Microsoft.SqlServer.Smo.dll
  • Pivot or transpose a table in SQL Server without GROUPING BY
  • SqlFunction fails to open context connection despite DataAccessKind.Read present
  • How do you change the datatype of a column in MS SQL?
  • Index performance
  • SQL Server Configuration Manager not found
  • Why is there a sort showing up in my execution plan?
  • How Can I use “Date” Datatype in sql server?
  • Adding a month to a date in T SQL
  • Sql Server 2008 MERGE - best way to get counts
  • Conversion failed when converting from a character string to uniqueidentifier - Two GUIDs
  • Update cached data
  • 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.