Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

How many content databases can you have?

  Asked By: Chaim    Date: Sep 08    Category: Sharepoint    Views: 2013

Does anyone know if there's a limitation on the number of content
databases that sharepoint (wss in particular) can handle?
I'd be interested in hearing from some people as to how large that
number has gotten for them.



2 Answers Found

Answer #1    Answered By: Keenan Whitehead     Answered On: Sep 08

I know of no hard-coded limit.

Answer #2    Answered By: Gopal Jamakhandi     Answered On: Sep 08

there are not hard code limits, but if you read the
following material (or view) then there seems some guidelines, but
you need to check this out in your own environment.
• Webcast: SharePoint Products and Technologies: Performance
and Capacity Planning Best Practices and Lessons Learned, Joel
Olsen, 26th May 2005.
• Webcast: How Microsoft IT Plans and Optimizes and Enterprise
SharePoint Infrastructure, 8th February 2005.
• Microsoft IT Showcase : Best Practices, experiences, and
global solutions from Microsoft IT: Microsoft SharePoint Products
and Technologies Performance at Microsoft, 20th June 2005.

The WSS admin help states some recommendations as to the number  of
Web front ends (4) to the number of SQL instances/servers, however
the data is currently only available for SQL 2000 and not SQL 2005.

Joel Olsen's blogg has quite a discussion on this topic.
117.entry Microsoft tries to now have no content  database bigger
than 50 GB. There are some SQL recommendations as to the number of
databases per SQL instance - I believe this is 100, but again this
could be the SQL 2000 guideline. This means that each SQL instance
could look after 2-5TB of databases.

Didn't find what you were looking for? Find more on How many content databases can you have? Or get search suggestion and latest updates.