|
Limit
|
Maximum value
|
Limit type
|
Size per column
|
|
Single line of text
|
276
|
Threshold
|
28 bytes
|
|
Multiple Lines of Text
|
192
|
Threshold
|
28 bytes
|
|
Choice
|
276
|
Threshold
|
28 bytes
|
|
Number
|
72
|
Threshold
|
12 bytes
|
|
Currency
|
72
|
Threshold
|
12 bytes
|
|
Date and Time
|
48
|
Threshold
|
12 bytes
|
|
Lookup
|
96
|
Threshold
|
4 bytes
|
|
Yes / No
|
96
|
Threshold
|
5 bytes
|
|
Person or group
|
96
|
Threshold
|
4 bytes
|
|
Hyperlink or picture
|
138
|
Threshold
|
56 bytes
|
|
Calculated
|
48
|
Threshold
|
28 bytes
|
|
GUID
|
6
|
Threshold
|
20 bytes
|
|
Int
|
96
|
Threshold
|
4 bytes
|
|
Managed metadata
|
94
|
Threshold
|
40 bytes for the first, 32 bytes for each subsequent
|
10 January, 2012
Column Limits:SharePoint Server 2010
List and library limits:SharePoint 2010
| Limit | Maximum value | Limit type | Notes |
|---|---|---|---|
List row size
|
8,000 bytes per row
|
Boundary
|
Each list or library item can only occupy 8,000 bytes in total in the database. 256 bytes are reserved for built-in columns, which leaves 7,744 bytes for end-user columns. For details on how much space each kind of field consumes, see Column limits.
|
File size
|
2 GB
|
Boundary
|
The default maximum file size is 50 MB. This can be increased up to 2 GB, however a large volume of very large files can affect farm performance.
|
Documents
|
30,000,000 per library
|
Supported
|
You can create very large document libraries by nesting folders, or using standard views and site hierarchy. This value may vary depending on how documents and folders are organized, and by the type and size of documents stored.
|
Major versions
|
400,000
|
Supported
|
If you exceed this limit, basic file operations—such as file open or save, delete, and viewing the version history— may not succeed.
|
Items
|
30,000,000 per list
|
Supported
|
You can create very large lists using standard views, site hierarchies, and metadata navigation. This value may vary depending on the number of columns in the list and the usage of the list.
|
Rows size limit
|
6 table rows internal to the database used for a list or library item
|
Supported
|
Specifies the maximum number of table rows internal to the database that can be used for a list or library item. To accommodate wide lists with many columns, each item may be wrapped over several internal table rows, up to six rows by default. This is configurable by farm administrators through the object model only. The object model method is SPWebApplication.MaxListItemRowStorage.
|
Bulk operations
|
100 items per bulk operation
|
Boundary
|
The user interface allows a maximum of 100 items to be selected for bulk operations.
|
List view lookup threshold
|
8 join operations per query
|
Threshold
|
Specifies the maximum number of joins allowed per query, such as those based on lookup, person/group, or workflow status columns. If the query uses more than eight joins, the operation is blocked. This does not apply to single item operations. When using the maximal view via the object model (by not specifying any view fields), SharePoint will return up to the first eight lookups.
|
List view threshold
|
5,000
|
Threshold
|
Specifies the maximum number of list or library items that a database operation, such as a query, can process at the same time outside the daily time window set by the administrator during which queries are unrestricted.
|
List view threshold for auditors and administrators
|
20,000
|
Threshold
|
Specifies the maximum number of list or library items that a database operation, such as a query, can process at the same time when they are performed by an auditor or administrator with appropriate permissions. This setting works with Allow Object Model Override.
|
Subsite
|
2,000 per site view
|
Threshold
|
The interface for enumerating subsites of a given Web site does not perform well as the number of subsites surpasses 2,000. Similarly, the All Site Content page and the Tree View Control performance will decrease significantly as the number of subsites grows.
|
Coauthoring in Microsoft Word and Microsoft PowerPoint for .docx, .pptx and .ppsx files
|
10 concurrent editors per document
|
Threshold
|
Recommended maximum number of concurrent editors is 10. The boundary is 99.
If there are 99 co-authors who have a single document opened for concurrent editing, any user after the 100th user sees a "File in use" error and have to view a read-only copy.
More than 10 co-editors will lead to a gradually degraded user experience with more conflicts and users will have to go through more iterations to get their changes to upload successfully.
|
Security scope
|
1,000 per list
|
Threshold
|
The maximum number of unique security scopes set for a list should not exceed 1,000.
A scope is the security boundary for a securable object and any of its children that do not have a separate security boundary defined. A scope contains an Access Control List (ACL), but unlike NTFS ACLs, a scope can include security principals that are specific to SharePoint Server. The members of an ACL for a scope can include Windows users, user accounts other than Windows users (such as forms-based accounts), Active Directory groups, or SharePoint groups.
|
List of all SharePoint 2010 and Office Server 2010 SP1 packages
All SP1 packages are available for download from Microsoft Download Center. You can download and install the following service packs for each product that you have installed.
| Package name | How to obtain the package | Knowledge Base article |
|---|---|---|
| Microsoft SharePoint Server 2010 Service Pack 1 |  |
2460045 Description of SharePoint Server 2010 SP1
|
| Microsoft SharePoint and Project Server 2010 Service Pack 1 | |
2460047 Description of Project Server 2010 SP1
|
| Microsoft Office Web Apps Service Pack 1 | |
2460073 Description of Office Web Apps SP1
|
| Microsoft Search Server 2010 Service Pack 1 | |
2460070 Description of Search Server 2010 SP1
|
| Microsoft FAST Search Server 2010 for SharePoint Service Pack 1 | |
2460039 Description of FAST Search Server 2010 for SharePoint SP1
|
| Microsoft Groove Server 2010 Service Pack 1 | |
2460067 Description of Groove Server 2010 SP1
|
| Microsoft 2010 Server Language Pack Service Pack 1 | |
2460056 Description of Office Servers 2010 Language Pack SP1
|
| Microsoft SharePoint Foundation 2010 Service Pack 1 | |
2460058 Description of SharePoint Foundation 2010 SP1
|
| Microsoft SharePoint Foundation 2010 Language Pack Service Pack 1 | |
2460059 Description of SharePoint Foundation 2010 Language Pack SP1
|
| Microsoft SharePoint 2010 Indexing Connector for Documentum Service Pack 1 | |
2460054 Description of SharePoint 2010 Indexing Connector for Documentum SP1
|
Subscribe to:
Posts (Atom)