locked
numbers of site collections in the web apps ? RRS feed

  • Question

  • I can see that http://technet.microsoft.com/en-us/library/cc262787(office.12).aspx seems to say that 150,000 is a good maximum, but then goes on to say that 50,000 per web application is a good maximum, the first figure being in the Site Objects table, the second being in the logical architecture objects table - which is the figure we should be trying to stick to

     

    Site object Guidelines for acceptable performance Notes Scope of impact when performance degrades

    Site collection

    50,000 per content database

    Total farm throughput degrades as the number of site collections increases.

    Farm

    Site collection

    150,000 per Web application

    This limit is theoretical, and is dependent largely upon:

    • Performance of the database server on which the configuration database resides.

    • Performance of the Web servers in the farm.

    • Network bandwidth between the Web servers and the database server.

    This is not a hard limit, and assumes a single database server. Your environment may not be able to host this many site collections per Web application. Distributing content databases across additional database servers can increase the effective limit of the number of site collections per Web application. You should perform testing to determine the actual effective limit in your environment.

    Farm

     

    vs

     

    Logical architecture object Guidelines for acceptable performance Notes

    Shared Services Provider (SSP)

    3 per farm (20 per farm maximum)

     

    Zone

    5* per farm

    The number of zones defined for a farm is hard coded to 5.

    Web application

    99 per SSP

    This limit includes the number of Web applications on child farms consuming resources on this SSP.

    Internet Information Services (IIS) application pool

    8 per Web server

    Maximum number is determined by hardware capabilities.

    Site collection

    50,000 per Web application

     

    Content database

    100 per Web application

     

    Site collection

    50,000 per database

    Wednesday, March 23, 2011 2:23 PM

Answers

All replies

  • I don't understand the question. These are figures for two different things.

    You can have several content databases in a web application.


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Wednesday, March 23, 2011 2:32 PM
  • Then examine the table more carefully

    Site collection

    150,000 per Web application

    Site collection

    50,000 per Web application

    I bolded them in the table above but obviously that wasn't clear enough

    Yes - there is also an entry for 50,000 Site Collections/database - in fact there are 2 - but I want to understand why there are 2 different entrties for Site Collections/Web app

     

    Thursday, March 24, 2011 8:07 AM
  • Sorry the second bold was at the bottom of the list and I didn't see it.

    They seem at the bottom to be just repeating (as a summary) what they said at the top. I imagine that whoever wrote the paper made a mistake when repeating the 150,000 per web application and simply dropped the 1 making it 50,000 per web application.

    So, well spotted, but I think all you have done is to have spotted an error in the document.


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Thursday, March 24, 2011 12:50 PM
  • In conclusion then - according to Technet the limit is 150,000 Site collections/Web app

    I'm not trying to spot errors - I'm trying to understand the limits. I need this info for capacity planning our environments

    Thanks for your help

     

    Thursday, March 24, 2011 3:56 PM
  • That's my assumption.

    It seems likely that they took more care when writing the details at the top than when knocking off the summary at the bottom.

    There are probably several other papers where these figures occur but I don't have any off hand to offer you.

    Mike

    P.S. Here: http://technet.microsoft.com/en-us/library/cc287790(office.12).aspx

    150,00 it is.


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    • Edited by Mike Walsh FIN Thursday, March 24, 2011 5:40 PM P.S. added after Bing search
    • Marked as answer by Leoyi Sun Tuesday, March 29, 2011 9:47 AM
    Thursday, March 24, 2011 5:38 PM