x

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?

more ▼

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

Larry Sumuri gravatar image

Larry Sumuri
47 2 2 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort oldest

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

more ▼

answered Apr 07 '10 at 12:59 AM

CirqueDeSQLeil gravatar image

CirqueDeSQLeil
4k 10 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)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x235
x61
x18

asked: Apr 07 '10 at 12:03 AM

Seen: 832 times

Last Updated: Apr 07 '10 at 12:03 AM