SQL Server Capabilities

Is there a guideline on the number of databases that can be added onto a SQL Server isntance, basically how do we 'know' when not to be adding any more databases onto an instance?

asked Apr 07 '10 at 12:03 AM in Default

Larry Sumuri
47 ● 2 ● 2 ● 2

(comments are locked)

1 answer:

You are permitted 32,767 databases per instance of SQL Server.

However, hardware is a limiting factor to the number of databases that can be served up efficiently.

http://msdn.microsoft.com/en-us/library/ms143432.aspx

answered Apr 07 '10 at 12:59 AM

CirqueDeSQLeil
3.9k ● 6 ● 11 ● 15

As Cirque said, the harddrive space and ability to manage the traffic coming in and out of the server is much more of an issue than the absolute number of databases.

Apr 07 '10 at 01:17 AM TimothyAWiseman

When your server stops responding to TSQL statements, I think you've added one database too many.

Apr 07 '10 at 09:17 AM Grant Fritchey ♦♦

(comments are locked)