3 years ago, I had published “How big can my SharePoint 2007 installation be?”
Well, SharePoint 2010 has significant under the covers improvements. So, how big can your SharePoint 2010 installation be?
There are three kinds of limits you should know about
- Hard limits that cannot be exceeded by design.
- Configurable that are, well configurable – but the default values are set for a pretty good reason, so if you need to tweak, plan and understand before you tweak.
- Soft limits, you can exceed them, but it is not recommended that you do.
Before you read any of the limits, read these two important disclaimers -
1. The limit depends on what you’re doing. So, don’t take the below as gospel, the reality depends on your situation.
2. There are many additional considerations in planning your SharePoint solution scalability and performance, besides just the below.
So with those in mind, here goes.
Hard Limits -
| Zones per web app | 5 |
| RBS NAS performance | Time to first byte of any response from NAS must be less than 20 milliseconds |
| List row size | 8000 bytes driven by how SP stores list items internally |
| Max file size | 2GB (default is 50MB, configurable). RBS does not increase this limit. |
| Search metadata properties | 10,000 per item crawled (pretty damn high, you’ll never need to worry about it). |
| Max # of concurrent in-memory enterprise content types | 5000 per web server, per tenant |
| Max # of external system connections | 500 per web server |
| PerformancePoint services using Excel services as a datasource | No single query can fetch more than 1 million excel cells |
| Office Web Apps Renders | One doc per second, per CPU core, per Application server, limited to a maximum of 8 cores. |
Configurable Limits -
| Row Size Limit | 6, configurable via SPWebApplication.MaxListItemRowStorage property |
| List view lookup | 8 join operations per query |
| Max number of list items that a single operation can process at one time in normal hours | 5000 Configurable via SPWebApplication.MaxItemsPerThrottledOperation Also you get a warning at 3000, which is configurable via SPWebApplication.MaxItemsPerThrottledOperationWarningLevel In addition, throttle overrides can be requested, throttle overrides can be disabled, and time windows can be set when throttle is disabled. |
| Max number of list items for administrators that a single operation can process at one time in normal hours | 20000 Configurable via SPWebApplication.MaxItemsPerThrottledOperationOverride |
| Enumerating subsites | 2000 |
| Word and Powerpoint co-authoring simultaneous editors | 10 (Hard limit is 99). |
| # of webparts on a page | 25 |
| Search Crawl DBs per search service app | 10 |
| Items per crawl db | 25 million |
| Search Keywords | 200 per site collection. There is a max limit of 5000, which can then be modified by editing the web.config/client.config. |
| Concurrent # of workflows on a content db | 15. Workflows running in the timer service are not counted in this limit. Further workflows are queued. Can be configured via the Set-SPFarmConfig powershell commandlet. |
| Number of events picked by the workflow timer job and delivered to workflows | 100. You can increase this limit by running additional instances of the workflow timer service. |
| Visio services file size | 50MB |
| Visio web drawing recalculation timeout | 120 seconds Configurable via – Powershell commandlet Set-SPVisioPerformance |
| Visio services minimum and maximum cache age for data connected diagrams | 0 to 24 hours. Default is 60 minutes. Configurable via – Powershell commandlet Set-SPVisioPerformance |
Soft Limits -
| Content Databases | 300 per web app |
| Application Pools | 10 per web server |
| Managed Paths | 20 per web app |
| Content Database Size | 200GB per Content DB |
| Size of 1 site collection | 100GB |
| # of sites in a site collection | 250,000 |
| Documents in a library | 30 Million, with nesting. Depends heavily on type and usage and size of documents. |
| Items | 30 million. Depends heavily on usage of items. |
| SPGroups one SPUser can be in | 5000 |
| Users in a site collection | 2 million, depends on UI, nesting, containers and underlying user store |
| AD Principals in a SPGroup | 5000 |
| SPGroups in a site collection | 10000 |
| Search Service Instances | 20 |
| Indexed Items in Search | 100 million |
| Crawl Log entries | 100 million |
| Search Alerts | 1 million per search application |
| Search Crawled Properties | 1/2 million |
| URL removals in search | 100 removals per operation |
| User Profiles | 2 million per service application |
| Social Tags | 500 million per social database |
Comment on the article ....
