List Size Limit within SharePoint 2010

352565 pts.
Tags:
Sharepoint 2010
What’s the list size limit within SharePoint 2010?

This question is from the Microsoft Live Chat which took place on June 1st.



Software/Hardware used:
SharePoint 2010

Answer Wiki

Thanks. We'll let you know when a new response is added.

There is capacity planning guidance–very detailed guidance!–on TechNet. Capacity is really about performance–there are very few hard-wired limits–and performance is based on usage and content.

Here are the software boundaries and capacity planning thresholds and limits. http://technet.microsoft.com/en-us/library/cc262787.aspx. Short answer: SharePoint 2010 scales further (way further) and more flexibly than ever before

Some guidelines include: 100GB per site collection, 200GB per content database (unless you have single-site document repositories, in which case TBs are supported), 300 content DBs per web app, 250,000 Web sites per site collection (2,000 under any one site), and tens of millions of items/documents per list/library. But again, these are HIGHLY dependent upon hardware, topology, usage, etc.

There is no hard limit on the number of items in a list. A good rule of thumb is 5,000. 5,000 are the new 2,000 :)

Oh sorry–LIST size limit is tens of millions of items. However you can manage the performance of lists (Spencer’s note about 5,000) in several ways. It’s all about query (and view)… THOSE are the limits… the list itself can have tens of millions of items.

The feature we’re talking about is List Throttling, which allows an admin to control the impact of large lists on the rest of the farm.

<i>This question was answered by Spencer Harbar, Enterprise Architect at Microsoft and Dan Holme, Consultant and Trainer, Intellium.</i>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following