I was doing an analysis for a client to figure out if there were any capacity
improvements on the new SharePoint 2013 RTM compared to SharePoint 2010 and I
thought I would put it in a chart and make it available for my blog readers.
What I found was that besides the new features, the most significant amount of
changes were on the limits for Search as search has had some big underlying
architecture changes for SharePoint in this release.
This data is taken from the Microsoft TechNet article entitled: SharePoint Server 2010 capacity management: Software boundaries and limits as well as the article entitled: Software boundaries and limits for SharePoint 2013. To get more detailed information, go directly to these articles.
Disclaimer: As SharePoint 2013 RTM has just been released, I’m sure there are still updates being made to the article so please refer to the TechNet articles for any more information required as well as updates. Microsoft states that some values in this article are based on test results from SharePoint 2010 Products and may not represent the final values for SharePoint Server 2013 and that they will update the article with appropriate values as SharePoint Server 2013 test data becomes available. Microsoft also states that this data is just a guideline to use your planning and is based on testing performed at Microsoft, on live properties and your results are likely to vary based on the equipment you use and the features and functionality that you implement for your sites.
I will try and update this chart as they release more information.
[1] http://technet.microsoft.com/en-us/library/cc262787(v=office.14).aspx
[2] http://technet.microsoft.com/en-us/library/cc262787(office.15).aspx
This data is taken from the Microsoft TechNet article entitled: SharePoint Server 2010 capacity management: Software boundaries and limits as well as the article entitled: Software boundaries and limits for SharePoint 2013. To get more detailed information, go directly to these articles.
Disclaimer: As SharePoint 2013 RTM has just been released, I’m sure there are still updates being made to the article so please refer to the TechNet articles for any more information required as well as updates. Microsoft states that some values in this article are based on test results from SharePoint 2010 Products and may not represent the final values for SharePoint Server 2013 and that they will update the article with appropriate values as SharePoint Server 2013 test data becomes available. Microsoft also states that this data is just a guideline to use your planning and is based on testing performed at Microsoft, on live properties and your results are likely to vary based on the equipment you use and the features and functionality that you implement for your sites.
I will try and update this chart as they release more information.
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 | 300 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 | 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 |
2,000 recommended 5,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 collection
|
Not Published | 2,000,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 | 1,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
|
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/2049 |
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 |
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 |
Number of nodes in managed navigation term set | Not Available in SharePoint 2010 | 2000
|
[1] http://technet.microsoft.com/en-us/library/cc262787(v=office.14).aspx
[2] http://technet.microsoft.com/en-us/library/cc262787(office.15).aspx
Comments
Post a Comment