| Limit Name | SharePoint 2010 Maximum Value | SharePoint 2013 Maximum Value |
| Web application limits | | |
| Web application | Not Published | 20 per farm |
| Content database | 300 per Web application | 500 per Web application |
| Zone | 5 per Web application | 5 per Web application |
| Managed path | 20 per Web application | 20 per Web application |
| Solution cache size | 300 MB per Web application | 300 MB per Web application |
| Site collection (sites and sub-sites) | 250,000 per Web application | 250,000 per Web application |
| | | |
| Web server and application server limits | | |
| Application pools | 10 per Web server | 10 per Web server
|
| | | |
| Content database limits | | |
| Number of content databases | 300 per Web application | 500 per farm |
| Content database size (general usage scenarios) | 200 GB per content database | 200 GB per content database |
| Content database size (all usage scenarios) | 4 TB per content database | 4 TB per content database |
| Content database size (document archive scenario) | No explicit content database limit | No explicit content database limit |
| Content database items | 60 million items including documents and list items | 60 million items including documents and list items |
| Site collections per content database | 2,000 recommended
5,000 maximum | 5,000 recommended
10,000 maximum |
| MySites per content database | Not Published | 5,000 per content database |
| Remote BLOB Storage (RBS) storage subsystem on Network Attached Storage (NAS) | Time to first byte of any response from the NAS cannot exceed 20 milliseconds | Time to first byte of any response from the NAS cannot exceed 20 milliseconds |
| | | |
| Site collection limits | | |
| Site collections per farm | Not Published | 750,000 per farm |
| Web site | 250,000 per site collection | 250,000 per site collection |
| MySites per farm | Not Published | 500,000 per farm |
| Site collection size | Maximum size of the content database | Maximum size of the content database |
| Number of device channels per publishing site collection | Not Available in SharePoint 2010 | 10 |
| | | |
| List and library limits | | |
| List row size | 8,000 bytes per row | 8,000 bytes per row |
| File size | 2 GB | 2 GB |
| Documents | 30,000,000 per library | 30,000,000 per library |
| Major versions | 400,000 | 400,000 |
| Minor versions | Not Published | 511 |
| Items | 30,000,000 per list | 30,000,000 per list |
| Rows size limit | 6 table rows internal to the database used for a list or library item | 6 table rows internal to the database used for a list or library item |
| Bulk operations | 100 items per bulk operation | 100 items per bulk operation |
| List view lookup threshold | 8 join operations per query | 8 join operations per query |
| List view threshold | 5,000 | 5,000 |
| List view threshold for auditors and administrators | 20,000 | 20,000 |
| Subsite | 2,000 per site view | 2,000 per site view |
| Coauthoring in Word and PowerPoint for .docx, .pptx and .ppsx files | 10 concurrent editors per document | 10 concurrent editors per document |
| Security scope | 1,000 per list | 50,000 per list |
| | | |
| Column limits | | |
| Single line of text | 276 | 276 |
| Multiple Lines of Text | 192 | 192 |
| Choice | 276 | 276 |
| Number | 72 | 72 |
| Currency | 72 | 72 |
| Date and Time | 48 | 48 |
| Lookup | 96 | 96 |
| Yes / No | 96 | 96 |
| Person or group | 96 | 96 |
| Hyperlink or picture | 138 | 138 |
| Calculated | 48 | 48 |
| GUID | 6 | 6 |
| Int | 96 | 96 |
| Managed metadata | 94 | 94 |
| | | |
| Page limits | | |
| Web parts | 25 per wiki or Web part page
| 25 per wiki or Web part page
|
| | | |
| Security limits | | |
| Number of SharePoint groups a user can belong to | 5,000 | 5,000 |
| Users in a site collection | 2 million per site collection | 2 million per site collection |
| Active Directory Principles/Users in a SharePoint group | 5,000 per SharePoint group | 5,000 per SharePoint group |
| SharePoint groups | 10,000 per site collection | 10,000 per site collection |
| Security principal: size of the Security Scope | 5,000 per Access Control List (ACL) | 5,000 per Access Control List (ACL) |
| | | |
| Search limits | | |
| Search service applications | 20 per farm | 20 per farm |
| Crawl databases | 10 crawl databases per search service application
25 million items per crawl database | 5 crawl databases per search service application |
| Crawl components | 16 per search service application | 2 per search service application |
| Index components | Not Published | 60 per Search service application |
| Index partitions | 20 per search service application
128 total | 20 per search service application |
| Index replicas | Not Available in SharePoint 2010 | 3 per index partition |
| Indexed items | 100 million per search service application;
10 million per index partition | 100 million per search service application;
10 million per index partition |
| Crawl log entries | 100 million per search application | 100 million per search application |
| Property databases | 10 per search service application;128 total | 10 per search service application;128 total |
| Link database | Not Available in SharePoint 2010 | Two per Search service application |
| Query processing components | 128 per search application
64/(total crawl components) per server | 1 per server computer |
| Content processing components | Not Published | One per server computer |
| Scope rules | 100 scope rules per scope; 600 total per search service application | 100 scope rules per scope; 600 total per search service application |
| Scopes | 200 site scopes and 200 shared scopes per search service application | 200 site scopes and 200 shared scopes per search service application |
| Display groups | 25 per site | 25 per site |
| Alerts | 1,000,000 per search application(seems like a mistake) | 100,000 per search application |
| Content sources | 50 per search service application | 50 per search service application |
| Start addresses | 100 per content source | 100 per content source |
| Concurrent crawls | 20 per search application | 20 per search application |
| Crawled properties | 500,000 per search application | 500,000 per search application |
| Crawl impact rule | 100 | no limit |
| Crawl rules | 100 per search service application | no limit |
| Managed properties | 100,000 per search service application | 50,000 per search service application |
| Values per managed property | Not Published | 100 |
| Indexed managed property size | Not Published | 512 KB per searchable/queryable managed property |
| Managed property mappings | 100 per managed property | 100 per managed property |
| Retrievable managed property size | Not Published | 16 KB per managed property |
| Sortable and refinable managed property size | Not Published | 16 KB per managed property |
| URL removals | 100 removals per operation | 100 removals per operation |
| Authoritative pages | 1 top level and minimal second and third level pages per search service application | 1 top level and minimal second and third level pages per search service application |
| Keywords | 200 per site collection | 200 per site collection |
| Metadata properties recognized | 10,000 per item crawled | 10,000 per item crawled |
| Analytics processing components | Not Available in SharePoint 2010 | 6 per Search service application |
| Analytics reporting database | Not Available in SharePoint 2010 | Four per Search service application |
| Maximum eDiscovery KeywordQuery text length | Not Available in SharePoint 2010 | 16 KB |
| Maximum KeywordQuery text length | Not Available in SharePoint 2010 | 4 KB |
| Maximum length of eDiscovery KeywordQuery text at Search service application level | Not Available in SharePoint 2010 | 20 KB |
| Maximum length of KeywordQuery text at Search service application level | Not Available in SharePoint 2010 | 20 KB |
| Maximum size of documents pulled down by crawler | Not Available in SharePoint 2010 | 64 MB (3 MB for Excel documents) |
| Navigable results from search | Not Available in SharePoint 2010 | 100,000 per query request per Search service application |
| Number of entries in a custom entity extraction dictionary | Not Available in SharePoint 2010 | 1 million |
| Number of entries in a custom search dictionary | Not Available in SharePoint 2010 | 5,000 terms per tenant |
| Number of entries in a thesaurus | Not Available in SharePoint 2010 | 1 million |
| Ranking models | Not Available in SharePoint 2010 | 1,000 per tenant |
| Results removal | Not Available in SharePoint 2010 | No limit |
| Term size | Not Available in SharePoint 2010 | 300 characters |
| Unique terms in the index | Not Available in SharePoint 2010 | 2^31 (>2 billion terms) |
| Unique contexts used for ranking | Not Available in SharePoint 2010 | 15 unique contexts per rank model |
| User defined full text indexes | Not Available in SharePoint 2010 | 10 |
| | | |
| User Profile Service limits | | |
| User profiles | 2,000,000 per service application | 2,000,000 per service application |
| Social tags, notes and ratings | 500,000,000 per social database | 500,000,000 per social database |
| Maximum Number of Users Imported Via FIM | Not Published | 1000000 |
| | | |
| Content deployment limits | | |
| Content deployment jobs running on different paths | 20 | 20
|
| | | |
| Blog limits | | |
| Blog posts | 5,000 per site | 5,000 per site |
| Comments | 1,000 per post | 1,000 per post
|
| | | |
| Business Connectivity Services limits | | |
| ECT (in-memory) | 5,000 per Web server (per tenant) | 5,000 per Web server (per tenant) |
| External system connections | 500 per Web server | 500 per Web server |
| Database items returned per request | 2,000 per database connector | 2,000 per database connector |
| Response latency | Not Published | 600 seconds |
| Service response size | Not Published | 150,000,000 bytes |
| Filter Descriptor (in-store) | Not Published | 200 per ECT method |
| ECT Identifier (in-store) | Not Published | 20 per ECT |
| Database Item | Not Published | 1,000,000 per request
|
| | | |
| Workflow limits | | |
| Workflow postpone threshold | 15 | 15 |
| Workflow timer batch size | 100 | 100 |
| Workflow associations | Not Published | 100 per list |
| List items or documents that can be bulk created or uploaded to start workflow instances | Not Published | 5,000 items |
| Published workflow definitions per site | Not Published | 1,000 per site |
| Total workflow associations per site | Not Published | 1,799 per site |
| Maximum workflow definition (xaml) size | Not Published | 5,120 KB |
| Maximum depth of a workflow sub-step in xaml (workflow complexity) | Not Published | 121 levels |
| Workflow instance activations per second per web server | Not Published | 6 per second |
| Rest calls from SharePoint workflow per second per web server | Not Published | 60 per second |
| Workflow variable value size | Not Published | 256 KB |
| Maximum list size for workflow lookups to non-indexed fields | Not Published | 5,000 items per list view |
| Maximum list size for auto-start workflow associations | Not Published | 10 million items per list
|
| | | |
| Managed Metadata term store (database) limits | | |
| Maximum number of levels of nested terms in a term store | 7 | 7 |
| Maximum number of term sets in a term store | 1,000 | 1,000 |
| Maximum number of terms in a term set | 30,000 | 30,000 |
| Total number of items in a term store | 1,000,000 | 1,000,000 |
| Number of Variation Labels | Not Available in SharePoint 2010 | 209 per term store
|
| Number of terms in managed navigation term set | Not Available in SharePoint 2010 | 2,000 |
| | | |
| Visio Services limits | | |
| File size of Visio Web drawings | 50 MB | 50 MB |
| Visio Web drawing recalculation time-out | 120 seconds | 120 seconds |
| Visio Services minimum cache age (data connected diagrams) | Minimum cache age: 0 to 24hrs | Minimum cache age: 0 to 24hrs |
| Visio Services maximum cache age (non-data connected diagrams) | Maximum cache age: 0 to 24hrs | Maximum cache age: 0 to 24hrs
|
| | | |
| SharePoint Web Analytics service limits | | |
| SharePoint entities | 30,000 per farm when Web Analytics is enabled | Deprecated |
| | | |
| PerformancePoint Services limits | | |
| Cells | 1,000,000 per query on Excel Services data source | 1,000,000 per query on Excel Services data source |
| Columns and rows | 15 columns by 60,000 rows | 15 columns by 60,000 rows |
| Query on a SharePoint list | 15 columns by 5,000 rows | 15 columns by 5,000 rows |
| Query on a SQL Server data source | 15 columns by 20,000 rows | 15 columns by 20,000 rows |
| | | |
| Word Automation Services limits | | |
| Input file Size | 512 MB | 512 MB |
| Frequency with which to start conversions (minutes) | 1 minute (recommended)
15 minutes (default)
59 minutes (boundary) | 1 minute (recommended)
15 minutes (default)
59 minutes (boundary) |
| Number of conversions to start per conversion process | For PDF/XPS output formats: 30 x M For all other output formats: 72 x M Where M is the value of Frequency with which to start conversions (minutes) | For PDF/XPS output formats: 30 x M For all other output formats: 72 x M Where M is the value of Frequency with which to start conversions (minutes) |
| Conversion job size | 100,000 conversion items | 100,000 conversion items |
| Total active conversion processes | N-1, where N is the number of cores on each application server | N-1, where N is the number of cores on each application server |
| Word Automation Services database size | 2 million conversion items | 2 million conversion items
|
| | | |
| SharePoint Workspace limits (Renamed to Office Live Workspace) | | |
| Office Live Workspace list items | 30,000 items per list | 30,000 items per list |
| Office Live Workspace documents | 1,800 documents limit in SharePoint Workspace | 1,800 documents in Office Live Workspace |
| | | |
| OneNote limits | | |
| Number of Sections and Section Groups in a OneNote Notebook (on SharePoint) | See limit for "Documents" in List and library limits | See limit for "Documents" in List and library limits |
| Maximum size of a section | See limit for "File size" in List and library limits | See limit for "File size" in List and library limits |
| Maximum size of an image, embedded file, and XPS OneNote printout in a OneNote section. | See limit for "File size" in List and library limits | See limit for "File size" in List and library limits |
| Maximum size of all images, embedded files, and XPS printouts in a single OneNote page. | Default limit is double the "File size" limit. | Default limit is double the "File size" limit. |
| Merge operations | One per CPU core per Web server | One per CPU core per Web server
|
| | | |
| Excel Services limits | | |
| Maximum workbook size | Not Published | 10 MB
|
| | | |
| Machine Translation Service limits | | |
| Input file size for binary files | Not Available in SharePoint 2010 | 524,288 KB per file |
| Input file size for text files | Not Available in SharePoint 2010 | 15,360 KB per file |
| Maximum character count for Microsoft Word Documents | Not Available in SharePoint 2010 | 10,000,000 per document |
| Total concurrent translation processes | Not Available in SharePoint 2010 | 5 |
| Delay between translations | Not Available in SharePoint 2010 | 59 minutes |
| Number of translations per translation process | Not Available in SharePoint 2010 | 1,000 per process |
| Maximum concurrent translation requests | Not Available in SharePoint 2010 | 300 |
| Files per translation job | Not Available in SharePoint 2010 | 100,000 files |
| Machine Translation Service database size | Not Available in SharePoint 2010 | 1,000,000 files
|
| | | |
| Office Web Application Service limits | | |
| Cache size | 100 GB | 100 GB |
| Renders | One per document per second per CPU core per application server (maximum eight cores) | One per document per second per CPU core per application server (maximum eight cores) |
| OneNote concurrent merge operations | Not Available in SharePoint 2010 | 8 per document
|
| | | |
| Project Server limits | | |
| End of project time | Date: 12/31/2049 | Date: 12/31/2149 |
| Deliverables per project plan | 1,500 deliverables | 1,500 deliverables |
| Number of fields in a view | 256 | 256 |
| Number of clauses in a filter for a view | 50 | 50
|
| | | |
| SharePoint Apps limits | | |
| Maximum Access app size on Office 365/SQL Azure | Not Available in SharePoint 2010 | 100 Mb/1GB |
| Apps displayed in Manage Licenses page | Not Available in SharePoint 2010 | 2,000 |
| Number of app licenses per tenant | Not Available in SharePoint 2010 | 1,000,000 |
| Number of apps displayed in the Add an App page | Not Available in SharePoint 2010 | 240 |
| Number of managers per app license | Not Available in SharePoint 2010 | 30 |
| Number of app licenses assigned to a user viewable by that user | Not Available in SharePoint 2010 | 2,000 |
| Number of apps in the corporate catalog viewable by a single user | Not Available in SharePoint 2010 | 500 |
| | | |
| Miscellaneous limits | | |
| Number of User agent substrings per device channel | Not Available in SharePoint 2010 | 150 |
| Number of SharePoint sources per EDiscovery case | Not Available in SharePoint 2010 | 100 |
| Number of Exchange sources (mailboxes) per EDiscovery case | Not Available in SharePoint 2010 | 1500 |
| Maximum size of EDiscovery Query | Not Available in SharePoint 2010 | 16K characters or 500 keywords |
| |
|
