Microsoft has published a set of documents that will help you plan your new SharePoint 2010 infrastructure.

In these documents you will find technical case studies, performance and capacity test results.  You will also find a document that will help you understand the tested performance and capacity limits of Microsoft SharePoint Server 2010.

Here is a list of the documents:

·        SharePoint Server 2010 performance and capacity technical case studies

·        SharePoint Server 2010 capacity management: software boundaries and limits

·        Capacity management and sizing for SharePoint Server 2010

·        SharePoint Server 2010 performance and capacity test results and recommandations

 

Exemples of recommanded maximum value that are discussed in these documents:

Limit

Maximum value

Limit type

Notes

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 one time, outside of the daily time window set by the administrator during which queries are unrestricted.

List View Threshold size 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 one time when performed by an auditor or administrator with appropriate permissions. This setting works in conjunction with Allow Object Model Override.

List row size

8,000 bytes per row

Boundary

For each SharePoint list or library item, it is only allowed to occupy 8000 bytes in total in the database. 256 bytes are reserved for built-in SharePoint columns, which leaves 7744 bytes for end-user columns. For details on how much space each type of field consumes, please look at the Column Limits.

File size

2GB

Boundary

The default maximum file size is 50 MB. This can be increased up to 2 GB, but a large volume of very large files can impact farm’s performance

Documents

50,000,000 per library

Supported

You can create very large document libraries by nesting folders, 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.

Items

tens of millions 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.

 

Serge Tremblay
MVP SharePoint

 

Advertisements