locked
---What is a Library Size Limit IN MEGABYTES ? RRS feed

  • Question

  • Hi guys,

    I am trying to find out what is an SP Library size limit in Megabytes?

    In  MS Technet article about boundaries specifies: 2MB per file (max), 30 mill. docs per library. And that donsn't answer my question. I need to know what is the size limit in MB? (I can't find any info online)

    Does anybody knows?

    Thank you.  :)

     

    Friday, June 10, 2011 2:45 PM

Answers

  • There isn't a physical limit per say for a library since the database will be the one what will determine the limitation.  For example:  the max database size for sql server 2008 r2 64 bit is

    524,272 terabytes

    and there could be one table with that size so in general rough calculations with metadata and such for the wss_content database, we can assume about 100-1000 terabytes for the document library (saying there is one site and one doc lib in it).

    HTH

    please don't try to break down the rough calculation since it is very rough.


    de Nada
    • Proposed as answer by MLSoung Friday, June 10, 2011 5:18 PM
    • Marked as answer by Seven M Thursday, June 16, 2011 7:42 AM
    Friday, June 10, 2011 5:18 PM
  • This is something you will need to test out in your environment. However, I have seen one client who was getting up to about 20GB of data in a single document library and they began to have problems. But this is anecdotal and you would need to verify for your setup. My point is that it may not be just a SQL database size limit issue.
    JD Wade
    Senior SharePoint Consultant, MCTS
    Horizons Consulting, Inc.
    Blog: http://wadingthrough.com
    Twitter: http://twitter.com/jdwade
    • Marked as answer by Seven M Thursday, June 16, 2011 7:42 AM
    Friday, June 10, 2011 6:08 PM

All replies

  • Here are some guidelines for size limits:  http://old.markharrison.co.uk/blog/2004/09/sharepoint-scaling-limits.htm 

    I don't know for sure if there is (or is not) a limit to the entire library.  Since individual items can be up to 2 GB, I would assume it's pretty large. 

    Friday, June 10, 2011 3:22 PM
  • Thanks Alex,

    But That link that you've provided is for SP 2007.

    Friday, June 10, 2011 3:48 PM
  • Well it certainly is.  Sorry for that! 

    Here is a lot of limit information for 2010.

    http://technet.microsoft.com/en-us/library/cc262787.aspx

    I skimmed the document so it may have more detailed information, but it does look like it says a site collection should not exceed 100GB.

     

    Friday, June 10, 2011 4:00 PM
  • Yes, I paid attantion to that one, but it doesn't mean much, cos site collection can have many sites and many libraries. So at what point the library will complain and refuse to take the docs?
    Friday, June 10, 2011 4:54 PM
  • There isn't a physical limit per say for a library since the database will be the one what will determine the limitation.  For example:  the max database size for sql server 2008 r2 64 bit is

    524,272 terabytes

    and there could be one table with that size so in general rough calculations with metadata and such for the wss_content database, we can assume about 100-1000 terabytes for the document library (saying there is one site and one doc lib in it).

    HTH

    please don't try to break down the rough calculation since it is very rough.


    de Nada
    • Proposed as answer by MLSoung Friday, June 10, 2011 5:18 PM
    • Marked as answer by Seven M Thursday, June 16, 2011 7:42 AM
    Friday, June 10, 2011 5:18 PM
  • This is something you will need to test out in your environment. However, I have seen one client who was getting up to about 20GB of data in a single document library and they began to have problems. But this is anecdotal and you would need to verify for your setup. My point is that it may not be just a SQL database size limit issue.
    JD Wade
    Senior SharePoint Consultant, MCTS
    Horizons Consulting, Inc.
    Blog: http://wadingthrough.com
    Twitter: http://twitter.com/jdwade
    • Marked as answer by Seven M Thursday, June 16, 2011 7:42 AM
    Friday, June 10, 2011 6:08 PM
  • Thank you, guys for your responses!
    Friday, June 10, 2011 7:10 PM