question

Larry Sumuri avatar image
Larry Sumuri asked

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?

databasebest-practiceserver-instances
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
CirqueDeSQLeil avatar image
CirqueDeSQLeil answered

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

2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

TimothyAWiseman avatar image TimothyAWiseman commented ·
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.
1 Like 1 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
When your server stops responding to TSQL statements, I think you've added one database too many.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.