Sharepoint 2010 Facts & Numbers

23 08 2010

Hi everyone,

hopefully coming out from a long silence due to an unusual amount of work, and some vacations somewhere in the middle, I’ve started to put together a post in the line of the previous Facts and Numbers for MOSS 2007.

I will keep this as living post, in order to update as time and info goes by.

References:

Prior to reading the facts bellow, DO READ the following topics:

  • The numbers represent SOFT LIMITS and reflect a testing effort that should be understood. Read the tests description ans scenarios in order to grasp the full picture
  • Read the documentation in the links above

The following information is a copy of information posted at technet. Check the link for updated data.

Limits by hierarchy

This section provides limits sorted by the logical hierarchy of a SharePoint Server 2010 farm.

Web application limits

The following table lists the recommended guidelines for Web applications.

Limit Maximum value Limit type Notes
Content database 300 per Web application Supported With 300 content databases per Web application, end user operations such as opening the site or site collections are not affected. But administrative operations such as creating a new site collection will experience decrease in performance. We recommend that you use Windows PowerShell to manage the Web application when a large number of content databases are present, because the management interface becomes slow and difficult to navigate.
Zone 5 per Web application Boundary The number of zones defined for a farm is hard-coded to 5. Zones include Default, Intranet, Extranet, Internet, and custom.
Managed path 20 per Web application Supported Managed paths are cached on the Web server, and CPU resources are used to process incoming requests against the managed path list.Exceeding 20 managed paths per Web application adds more load to the Web server for each request.If you plan to exceed twenty managed paths in a given Web application, we recommend that you test for acceptable system performance.
Solution cache size 300 MB per Web application Threshold The solution cache allows the InfoPath Forms service to hold solutions in cache in order to speed up retrieval of the solutions. If the cache size is exceeded, solutions are retrieved from disk, which may slow down response times. You can configure the size of the solution cache by using the Windows PowerShell cmdlet Set-SPInfoPathFormsService. For more information, see Set-SPInfoPathFormsService.

Web server and application server limits

The following table lists the recommended guidelines for Web servers on the farm.

Limit Maximum value Limit type Notes
Application pools 10 per Web server Supported The maximum number is determined by hardware capabilities.This limit is dependent largely upon:

  • The amount of RAM allocated to the Web servers
  • The workload that the farm is serving, that is, the user base and the usage characteristics (a single highly active application pools can reach 10 GB or more)

Content database limits

The following table lists the recommended guidelines for content databases.

Limit Maximum value Limit type Notes
Content database size 200 GB per content database Supported We strongly recommended limiting the size of content databases to 200 GB to help ensure system performance.Content database sizes up to 1 terabyte are supported only for large, single-site repositories and archives with non-collaborative I/O and usage patterns, such as Records Centers. Larger database sizes are supported for these scenarios because their I/O patterns and typical data structure formats have been designed for, and tested at, larger scales. For more information about large-scale document repositories, see “Estimate Performance and Capacity Requirements for Large Scale Document Repositories”, available from Performance and capacity test results and recommendations (SharePoint Server 2010).A site collection should not exceed 100 GB unless it is the only site collection in the database.
Site collections per content database 2,000 recommended5,000 maximum Supported We strongly recommended limiting the number of site collections in a content database to 2,000. However, up to 5,000 site collections in a database are supported.These limits relate to speed of upgrade. The larger the number of site collections in a database, the slower the upgrade.The limit on the number of site collections in a database is subordinate to the limit on the size of a content database that has more than one site collection (200 GB). Therefore, as the number of site collections in a database increases, the average size of the site collections it contains must decrease.Exceeding the 2,000 site collection limit puts you at risk of longer downtimes during upgrades. If you plan to exceed 2,000 site collections, we recommend that you have a clear upgrade strategy, and obtain additional hardware to speed up upgrades and software updates that affect databases.To set the warning level for the number of sites in a content database, use the Windows PowerShell cmdlet Set-SPContentDatabase with the -WarningSiteCount parameter. For more information, see Set-SPContentDatabase.
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 Boundary When SharePoint Server 2010 is configured to use RBS, and the BLOBs reside on NAS storage, consider the following boundary.From the time that SharePoint Server 2010 requests a BLOB, until it receives the first byte from the NAS, no more than 20 milliseconds can pass.

Site collection limits

The following table lists the recommended guidelines for site collections.

Limit Maximum value Limit type Notes
Web site 250,000 per site collection Supported The maximum recommended number of sites and subsites is 250,000 sites.You can create a very large total number of Web sites by nesting subsites. For example, in a shallow hierarchy with 100 sites, each with 1,000 subsites, you would have a total of 100,000 Web sites. Or a deep hierarchy with 100 sites, each with 10 subsite levels would also contain a total of 100,000 Web sites.Note: Deleting or creating a site or subsite can significantly affect a site’s availability. Access to the site and subsites will be limited while the site is being deleted. Attempting to create many subsites at the same time may also fail.
Site collection size 100 GB per site collection Supported A site collection should not exceed 100 GB unless it is the only site collection in the database.Certain site collection actions, such as site collection backup/restore or the Windows PowerShell cmdlet Move-SPSite, cause large Microsoft SQL Server operations which can affect performance or fail if other site collections are active in the same database. For more information, see Move-SPSite.

List and library limits

The following table lists the recommended guidelines for lists and libraries. For more information, see the “Designing Large Lists and Maximizing List Performance” white paper available from Performance and capacity test results and recommendations (SharePoint Server 2010).

Limit Maximum value Limit type Notes
List row size 8,000 bytes per row Boundary Each list or library item can only occupy 8000 bytes in total in the database. 256 bytes are reserved for built-in columns, which leaves 7744 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 histor— 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.

Column limits

SharePoint Server 2010 data is stored in SQL Server tables. To allow for the maximum number of possible columns in a SharePoint list, SharePoint Server will create several rows in the database when data will not fit on a single row. This is called row wrapping.

Each time that a row is wrapped in SQL Server, an additional query load is put on the server when that item is queried because a SQL join must be included in the query. To prevent too much load, by default a maximum of six SQL Server rows are allowed for a SharePoint item. This limit leads to a particular limitation on the number of columns of each type that can be included in a SharePoint list. The following table describes the limits for each column type.

The row wrapping parameter can be increased beyond six, but this may result in too much load on the server. Performance testing is recommended before exceeding this limit. For more information, see the “Designing Large Lists and Maximizing List Performance” white paper that can be accessed from Performance and capacity test results and recommendations (SharePoint Server 2010).

Each column type has a size value listed in bytes. The sum of all columns in a SharePoint list cannot exceed 8,000 bytes. Depending on column usage, users can reach the 8,000 byte limitation before reaching the six-row row wrapping limitation.

Limit Maximum value Limit type Size per column Notes
Single line of text 276 Threshold 28 bytes SQL Server row wrapping occurs after each 64 columns in a SharePoint list. The default row wrapping value of six allows for a maximum of 384 Single line of text columns per SharePoint list (6 * 64 = 384). However, because the limit per SharePoint list item is 8000 bytes, of which 256 bytes are reserved for built-in SharePoint columns, the actual limit is 276 Single line of text columns.
Multiple Lines of Text 192 Threshold 28 bytes SQL Server row wrapping occurs after each 32 columns in a SharePoint list. The default row wrapping value of six allows for a maximum of 192 Multiple lines of text columns per SharePoint list (6 * 32 = 192).
Choice 276 Threshold 28 bytes SQL Server row wrapping occurs after each 64 columns in a SharePoint list. The default row wrapping value of 6 allows for a maximum of 384 Choice columns per SharePoint list (6 * 64 = 384); ); however because the limit per SharePoint list item is 8000 bytes, of which 256 bytes are reserved for built-in SharePoint columns, the actual limit should be 276 Single line of text columns.
Number 72 Threshold 12 bytes SQL Server row wrapping occurs after each 12 columns in a SharePoint list. The default row wrapping value of six allows for a maximum of 72 Number columns per SharePoint list (6 * 12 = 72).
Currency 72 Threshold 12 bytes SQL Server row wrapping occurs after each 12 columns in a SharePoint list. The default row wrapping value of six allows for a maximum of 72 Currency columns per SharePoint list (6 * 12 = 72).
Date and Time 48 Threshold 12 bytes SQL Server row wrapping occurs after each eight columns in a SharePoint list. The default row wrapping value of six allows for a maximum of 48 Date and Time columns per SharePoint list (6 * 8 = 48).
Lookup 96 Threshold 4 bytes SQL Server row wrapping occurs after each 16 columns in a SharePoint list. The default row wrapping value of six allows for a maximum of 96 single value Lookup columns per SharePoint list (6 * 16 = 96).
Yes / No 96 Threshold 5 bytes SQL Server row wrapping occurs after each 16 columns in a SharePoint list. The default row wrapping value of six allows for a maximum of 96 Yes / No columns per SharePoint list (6 * 16 = 96).
Person or group 96 Threshold 4 bytes SQL Server row wrapping occurs after each 16 columns in a SharePoint list. The default row wrapping value of six allows for a maximum of 96 Person or Group columns per SharePoint list (6 * 16 = 96).
Hyperlink or picture 138 Threshold 56 bytes SQL Server row wrapping occurs after each 32 columns in a SharePoint list. The default row wrapping value of six allows for a maximum of 192 Hyperlink or Picture columns per SharePoint list (6 * 32 = 192) ); however because the limit per SharePoint list item is 8000 bytes, of which 256 bytes are reserved for built-in SharePoint columns, the actual limit should be 138 Hyperlink or Picture columns.
Calculated 48 Threshold 28 bytes SQL Server row wrapping occurs after each eight columns in a SharePoint list. The default row wrapping value of six allows for a maximum of 48 Calculated columns per SharePoint list (6 * 8 = 48).
GUID 6 Threshold 20 bytes SQL Server row wrapping occurs after each column in a SharePoint list. The default row wrapping value of six allows for a maximum of 6 GUID columns per SharePoint list (6 * 1 = 6).
Int 96 Threshold 4 bytes SQL Server row wrapping occurs after each 16 columns in a SharePoint list. The default row wrapping value of six allows for a maximum of 96 Int columns per SharePoint list (6 * 16 = 96).
Managed metadata 94 Threshold 40 bytes for the first, 32 bytes for each subsequent The first Managed Metadata field added to a list is allocated four columns:

  • A lookup field for the actual tag
  • A hidden text field for the string value
  • A lookup field for the catch all
  • A lookup field for spillover of the catch all

Each subsequent Managed Metadata field added to a list adds two more columns:

  • A lookup field for the actual tag
  • A hidden text field for the string value

The maximum number of columns of Managed Metadata is calculated as (14 + (16 * (n-1))) where n is the row mapping value (default of 6).

External Data columns have the concept of a primary column and secondary columns. When you add an external data column, you can select some secondary fields of the external content type that you want to be added to the list. For example, given an External Content Type “Customer” which has fields like “ID”, “Name”, “Country”, and “Description”, when you add an External Data column of type “Customer” to a list, you can add secondary fields to show the “ID”, “Name” and “Description” of the Customer. Overall these are the columns that get added:

  • Primary column: A text field.
  • Hidden Id column: A multi-line text field.
  • Secondary columns: Each secondary column is a text/number/Boolean/multi-line text that is based on the data type of the secondary column as defined in the Business Data Catalog model. For example, ID might be mapped to a Number column; Name might be mapped to a Single line of text column; Description might be mapped to a Multiple lines of text column.

Page limits

The following table lists the recommended guidelines for pages.

Limit Maximum value Limit type Notes
Web parts 25 per wiki or Web part page Threshold This figure is an estimate based on simple Web Parts. The complexity of the Web parts dictates how many Web Parts can be used on a page before performance is affected.

Security limits

Limit Maximum value Limit type Notes
Number of SharePoint groups a user can belong to 5,000 Supported This is not a hard limit but it is consistent with Active Directory guidelines. There are several things that affect this number:

  • The size of the user token
  • The groups cache: SharePoint Server 2010 has a table that caches the number of groups a user belongs to as soon as those groups are used in access control lists (ACLs).
  • The security check time: as the number of groups that a user is a member of increases, the time that is required for the access check increases also.
Users in a site collection 2 million per site collection Supported You can add millions of people to your Web site by using Microsoft Windows security groups to manage security instead of using individual users.This limit is based on manageability and ease of navigation in the user interface.When you have many entries (security groups of users) in the site collection (more than one thousand), you should use Windows PowerShell to manage users instead of the UI. This will provide a better management experience.
Active Directory Principles/Users in a SharePoint group 5,000 per SharePoint group Supported SharePoint Server 2010 enables you to add users or Active Directory groups to a SharePoint group.Having up to 5,000 users (or Active Directory groups or users) in a SharePoint group provides acceptable performance.The activities most affected by this limit are as follows:

  • Fetching users to validate permissions. This operation takes incrementally longer with growth in number of users in a group.
  • Rendering the membership of the view. This operation will always require time.
SharePoint groups 10,000 per site collection Supported Above 10,000 groups, the time to execute operations is increased significantly. This is especially true of adding a user to an existing group, creating a new group, and rendering group views.
Security principal: size of the Security Scope 5,000 per Access Control List (ACL) Supported The size of the scope affects the data that is used for a security check calculation. This calculation occurs every time that the scope changes. There is no hard limit, but the bigger the scope, the longer the calculation takes.

Limits by feature

This section lists limits sorted by feature.

Search limits

The following table lists the recommended guidelines for Search.

Limit Maximum value Limit type Notes
SharePoint search service applications 20 per farm Supported Multiple SharePoint search service applications can be deployed on the same farm, because you can assign search components and databases to separate servers. The recommended limit of 20 is less than the maximum limit for all service applications in a farm.
Crawl databases and database Items 10 crawl databases per search service application25 million items per crawl database Threshold The crawl database stores the crawl data (time/status, etc) about all items that have been crawled. The supported limit is 10 crawl databases per SharePoint Search service application.The recommended limit is 25 million items per crawl database (or a total of four crawl databases per search service application).
Crawl components 16 per search service application Threshold The recommended limit per application is 16 total crawl components; with two per crawl database, and two per server, assuming the server has at least eight processors (cores).The total number of crawl components per server must be less than 128/(total query components) to minimize propagation I/O degradation. Exceeding the recommended limit may not increase crawl performance; in fact, crawl performance may decrease based on available resources on the crawl server, database, and content host.
Index partitions 20 per search service application; 128 total Threshold The index partition holds a subset of the search service application index. The recommended limit is 20. Increasing the number of index partitions results in each partition holding a smaller subset of the index, reducing the RAM and disk space that is needed on the query server hosting the query component assigned to the index partition. The boundary for the total number of index partitions is 128.
Indexed items 100 million per search service application; 10 million per index partition Supported SharePoint Search supports index partitions, each of which contains a subset of the search index. The recommended maximum is 10 million items in any partition. The overall recommended maximum number of items (e.g., people, list items, documents, Web pages) is 100 million.
Crawl log entries 100 million per search application Supported This is the number of individual log entries in the crawl log. It will follow the “Indexed items” limit.
Property databases 10 per search service application;128 total Threshold The property database stores the metadata for items in each index partition associated with it. An index partition can only be associated with one property store. The recommended limit is 10 property databases per search service application. The boundary for index partitions is 128.
Query components 128 per search application; 64/(total crawl components) per server Threshold The total number of query components is limited by the ability of the crawl components to copy files. The maximum number of query components per server is limited by the ability of the query components to absorb files propagated from crawl components.
Scope rules 100 scope rules per scope; 600 total per search service application Threshold Exceeding this limit will reduce crawl freshness, and delay potential results from scoped queries.
Scopes 200 per site Threshold This is a recommended limit per site. Exceeding this limit may reduce crawl efficiency and, if the scopes are added to the display group, affect end-user browser latency. Also, display of the scopes in the search administration interface degrades as the number of scopes passes the recommended limit.
Display groups 25 per site Threshold Display groups are used for a grouped display of scopes through the user interface. Exceeding this limit starts degrading the scope experience in the search administration interface.
Alerts 1,000,000 per search application Supported This is the tested limit.
Content sources 50 per search service application Threshold The recommended limit of 50 can be exceeded up to the boundary of 500 per search service application. However, fewer start addresses should be used, and the concurrent crawl limit must be followed.
Start addresses 100 per content source Threshold The recommended limit can be exceeded up to the boundary of 500 per content source. However, the more start addresses you have, the fewer content sources should be used. When you have many start address, we recommend that you put them as links on an html page, and have the HTTP crawler crawl the page, following the links.
Concurrent crawls 20 per search application Threshold This is the number of crawls underway at the same time. Exceeding this number may cause the overall crawl rate to decrease.
Crawled properties 500,000 per search application Supported These are properties that are discovered during a crawl.
Crawl impact rule 100 Threshold Recommended limit of 100 per farm. The recommendation can be exceeded; however, display of the site hit rules in the search administration interface is degraded. At approximately 2000 site hit rules, the Manage Site Hit Rules page becomes unreadable.
Crawl rules 100 per search service application Threshold This value can be exceeded; however, display of the crawl rules in the search administration interface is degraded.
Managed properties 100,000 per search service application Threshold These are properties used by the search system in queries. Crawled properties are mapped to managed properties.
Mappings 100 per managed property Threshold Exceeding this limit may decrease crawl speed and query performance.
URL removals 100 removals per operation Supported This is the maximum recommended number of URLs that should be removed from the system in one operation.
Authoritative pages 1 top level and minimal second and third level pages per search service application Threshold The recommended limit is one top-level authoritative page, and as few second -and third-level pages as possible to achieve the desired relevance.The boundary is 200 per relevance level per search application, but adding additional pages may not achieve the desired relevance. Add the key site to the first relevance level. Add more key sites at either second or third relevance levels, one at a time, and evaluate relevance after each addition to ensure that the desired relevance effect is achieved.
Keywords 200 per site collection Supported The recommended limit can be exceeded up to the maximum (ASP.NET-imposed) limit of 5000 per site collection given five Best Bets per keyword. If you exceed this limit, display of keywords on the site administration user interface will degrade. The ASP.NET-imposed limit can be modified by editing the Web.Config and Client.config files (MaxItemsInObjectGraph).
Metadata properties recognized 10,000 per item crawled Boundary This is the number of metadata properties that can be determined and potentially mapped or used for queries when an item is crawled.

User Profile Service limits

The following table lists the recommended guidelines for User Profile Service.

Limit Maximum value Limit type Notes
User profiles 2,000,000 per service application Supported A user profile service application can support up to 2 million user profiles with full social features functionality. This number represents the number of profiles that can be imported into the people profile store from a directory service, and also the number of profiles a user profile service application can support without leading to performance decreases in social features.
Social tags, notes and ratings 500,000,000 per social database Supported Up to 500 million total social tags, notes and ratings are supported in a social database without significant decreases in performance. However, database maintenance operations such as backup and restore may show decreased performance at that point.

Content deployment limits

The following table lists the recommended guidelines for content deployment.

Limit Maximum value Limit type Notes
Content deployment jobs running on different paths 20 Supported For concurrently running jobs on paths that are connected to site collections in the same source content database, there is an increased risk of deadlocks on the database. For jobs that must run concurrently, we recommend that you move the site collections into different source content databases.

Cc262787.note(en-us,office.14).gifNote:

Concurrent running jobs on the same path are not possible.

If you are using SQL Server snapshots for content deployment, each path creates a snapshot. This increases the I/O requirements for the source database.

For more information, see About deployment paths and jobs.

Blog limits

The following table lists the recommended guidelines for blogs.

Limit Maximum value Limit type Notes
Blog posts 5000 per site Supported The maximum number of blog posts is 5000 per site.
Comments 1000 per post Supported The maximum number of comments is 1000 per post.

Business Connectivity Services limits

The following table lists the recommended guidelines for Business Connectivity Services.

Limit Maximum value Limit type Notes
ECT (in-memory) 5000 per Web Server (per tenant) Boundary Total number of external content type (ECT) definitions loaded in memory at a given point in time on a Web server.
External system connections 500 per Web server Boundary Number of active/open external system connections at a given point in time. The default maximum value is 200; the boundary is 500. This limit is enforced at the Web Server scope, regardless of the kind of external system (for example, database, .NET assembly, and so on) The default maximum is used to restrict the number of connections. An application can specify a larger limit via execution context; the boundary enforces the maximum even for applications that do not respect the default.
Database items returned per request 2,000 per database connector Threshold Number of items per request the database connector can return.The default maximum of 2,000 is used by the database connector to restrict the number of result that can be returned per page. The application can specify a larger limit via execution context; the Absolute Max enforces the maximum even for applications that do not respect the default. The boundary for this limit is 1,000,000.

Workflow limits

The following table lists the recommended guidelines for workflow.

Limit Maximum value Limit type Notes
Workflow postpone threshold 15 Threshold 15 is the maximum number of workflows allowed to be executing against a content database at the same time, excluding instances that are running in the timer service. When this threshold is reached, new requests to activate workflows will be queued to be run by the workflow timer service later. As non-timer execution is completed, new requests will count against this threshold. This is limit can be configured by using the Set-SPFarmConfig Windows PowerShell cmdlet. For more information, see Set-SPFarmConfig.Note: This limit does not refer to the total number of workflow instances that can be in progress. Instead, it is the number of instances that are being processed. Increasing this limit increases the throughput of starting and completing workflow tasks but also increases load against the content database and system resources.
Workflow timer batch size 100 Threshold The number of events that each run of the workflow timer job will pick up and deliver to workflows. It is configurable by using Windows PowerShell. To allow for additional events, you can run additional instances of the Microsoft SharePoint Foundation Workflow Timer Service.

Managed Metadata term store (database) limits

The following table lists the recommended guidelines for managed metadata term stores.

Limit Maximum value Limit type Notes
Maximum number of levels of nested terms in a term store 7 Supported Terms in a term set can be represented hierarchically. A term set can have up to seven levels of terms (a parent term, and six levels of nesting below it.)
Maximum number of term sets in a term store 1000 Supported You can have up to 1000 term sets in a term store.
Maximum number of terms in a term set 30,000 Supported 30,000 is the maximum number of terms in a term set.

Cc262787.note(en-us,office.14).gifNote:

Additional labels for the same term, such as synonyms and translations, do not count as separate terms.

Total number of items in a term store 1,000,000 Supported An item is either a term or a term set. The sum of the number of terms and term sets cannot exceed 1,000,000. Additional labels for the same term, such as synonyms and translations, do not count as separate terms.

Cc262787.note(en-us,office.14).gifNote:

You cannot have both the maximum number of term sets and the maximum number of terms simultaneously in a term store.

Visio Services limits

The following table lists the recommended guidelines for instances of Visio Services in Microsoft SharePoint Server 2010.

Limit Maximum value Limit type Notes
File size of Visio Web drawings 50 MB Threshold Visio Services has a configuration setting that enables the administrator to change the maximum size of Web drawings that Visio processes.Larger file sizes have the following side effects:

  • Increase in the memory footprint of Visio Services.
  • Increase in CPU usage.
  • Reduction in application server requests per second.
  • Increase overall latency.
  • Increase SharePoint farm network load
VisioVisio Web drawing recalculation time-out 120 seconds Threshold Visio Services has a configuration setting that enables the administrator to change the maximum time that it can spend recalculating a drawing after a data refresh.A larger recalculation time-out leads to:

  • Reduction in CPU and memory availability.
  • Reduction in application requests per second.
  • Increase in average latency across all documents.

A smaller recalculation time-out leads to:

  • Reduction of the complexity of diagrams that can be displayed.
  • Increase in requests per second.
  • Decrease in average latency across all documents.
Visio Services minimum cache age (data connected diagrams) Minimum cache age: 0 to 24hrs Threshold Minimum cache age applies to data connected diagrams. It determines the earliest point at which the current diagram can be removed from cache.Setting Min Cache Age to a very low value will reduce throughput and increase latency, because invalidating the cache too often forces Visio to recalculate often and reduces CPU and memory availability.
Visio Services maximum cache age (non-data connected diagrams) Maximum cache age: 0 to 24hrs Threshold Maximum cache age applies to non-data connected diagrams. This value determines how long to keep the current diagram in memory.Increasing Max Cache Age decreases latency for commonly requested drawings.However, setting Max Cache Age to a very high value increases latency and slows throughput for items that are not cached, because the items already in cache consume and reduce available memory.

PerformancePoint Services limits

The following table lists the recommended guidelines for PerformancePoint Services in Microsoft SharePoint Server 2010.

Limit Maximum value Limit type Notes
Cells 1,000,000 per query on Excel Services data source Boundary A PerformancePoint scorecard that calls an Excel Services data source is subject to a limit of no more than 1,000,000 cells per query.
Columns and rows 15 columns by 60,000 rows Threshold The maximum number of columns and rows when rendering any PerformancePoint dashboard object that uses a Microsoft Excel workbook as a data source. The number of rows could change based on the number of columns.
Query on a SharePoint list 15 columns by 5000 rows Supported The maximum number of columns and row when rendering any PerformancePoint dashboard object that uses a SharePoint list as a data source. The number of rows could change based on the number of columns.
Query on a SQL Server data source 15 columns by 20000 rows Supported The maximum number of columns and row when rendering any PerformancePoint dashboard object that uses a SQL Server table data source. The number of rows could change based on the number of columns.

Word Automation Services limits

The following table lists the recommended guidelines for Word Automation Services.

Limit Maximum value Limit type Notes
Input file Size 512 MB Boundary Maximum file size that can be processed by Word Automation Services.
Frequency with which to start conversions (minutes) 1 minute (recommended) 15 minutes (default)59 minutes (boundary) Threshold This setting determines how often the Word Automation Services timer job executes. A lower number leads to the timer job running faster. Our testing shows that it is most useful to run this timer job once per minute.
Number of conversions to start per conversion process For PDF/XPS output formats: 30 x MFor all other output formats: 72 x M Where M is the value of Frequency with which to start conversions (minutes) Threshold The number of conversions to start affects the throughput of Word Automation Services.If these values are set higher than the recommended levels then some conversion items may start to fail intermittently and user permissions may expire. User permissions expire 24 hours from the time that a conversion job is started.
Conversion job size 100,000 conversion items Supported A conversion job includes one or more conversion items, each of which represents a single conversion to be performed on a single input file in SharePoint. When a conversion job is started (using the ConversionJob.Start method), the conversion job and all conversion items are transmitted over to an application server which then stores the job in the Word Automation Services database. A large number of conversion items will increase both the execution time of the Start method and the number of bytes transmitted to the application server.
Total active conversion processes N-1, where N is the number of cores on each application server Threshold An active conversion process can consume a single processing core. Therefore, customers should not run more conversion processes than they have processing cores in their application servers. The conversion timer job and other SharePoint activities also require occasional use of a processing core.We recommend that you always leave 1 core free for use by the conversion timer job and SharePoint.
Word Automation Services database size 2 million conversion items Supported Word Automation Services maintains a persistent queue of conversion items in its database. Each conversion request generates one or more records.Word Automation Services does not delete records from the database automatically, so the database can grow indefinitely without maintenance. Administrators can manually remove conversion job history by using the Windows PowerShell cmdlet Remove-SPWordConversionServiceJobHistory. For more information, see Remove-SPWordConversionServiceJobHistory.

SharePoint Workspace limits

The following table lists the recommended guidelines for Microsoft SharePoint Workspace 2010.

Limit Maximum value Limit type Notes
SharePoint Workspace synchronization 30,000 items per list Boundary SharePoint Workspace will not synchronize lists that have more than 30,000 items. This restriction exists because the time to download a list that has more than 30,000 items is very long, and resource usage is high.
SharePoint Workspace synchronization 1800 documents limit in SharePoint Workspace Boundary Users are warned when they have more than 500 documents in SharePoint Workspace, but they can continue to add documents.

OneNote limits

The following table lists the recommended guidelines for Microsoft OneNote Services.

Limit Maximum value Limit type Notes
Number of Sections and Section Groups in a OneNote Notebook (on SharePoint) See limit for “Documents” in List and library limits   Each section counts as one folder and one document in the list. Each section group counts as one folder and one document in the list.
Maximum size of a section See limit for “File size” in List and library limits   This maximum excludes any images, embedded files, and XPS printouts to OneNote that are larger than 100 KB. Images and embedded files larger than 100 KB are split out into their own binary files. This means that a section with 100 KB of typed data and four embedded Word documents of 1 MB each will be considered a 100 KB section.
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   Each item is stored as a separate binary file and is therefore subject to file size limits. Each print operation to OneNote will result in one XPS printout binary, even if the printout contains multiple pages.
Maximum size of all images, embedded files, and XPS printouts in a single OneNote page. Default limit is double the “File size” limit. Threshold This applies to embedded content in a single OneNote page, not a Section or Notebook. If users encounter this, they will see the following error in OneNote: jerrcStorageUrl_HotTableFull (0xE0000794). Users can work around this by splitting embedded content into different pages and deleting previous versions of the page. If users have to adjust this value (“Max Hot Table Size”), the effective limit is half of the absolute value they define (for example, specifying a 400 MB max hot table size means that the maximum size of all embedded content on a page is limited to 200 MB).
Merge operations One per CPU core per Web server Boundary OneNote merges combine changes from multiple users who are co-authoring a notebook. If no CPU core is available to run a merge, a conflict page is generated instead, which forces the user perform the merge manually).This limit applies whether OneNote is running as a client application or as a Microsoft Office Web Apps.

Office Web Application Service limits

The following table lists the recommended guidelines for Office Web Apps. Office client application limits also apply when an application is running as a Web app.

Limit Maximum value Limit type Notes
Cache size 100 GB Threshold Space available to render documents, created as part of a content database. By default, the cache available to render documents is 100 GB. We do not recommend that you increase the available cache.
Renders One per document per second per CPU core per application server (maximum eight cores) Boundary This is the measured average number of renders that can be performed of “typical” documents on the application server over a period of time.

Project Server limits

The following table lists the recommended guidelines for Microsoft Project Server. For more information about how to plan for Project Server, see Planning and architecture for Project Server 2010.

Limit Maximum value Limit type Notes
End of project time Date: 12/31/2049 Boundary Project plans cannot extend past the date 12/31/2049.
Deliverables per project plan 1500 deliverables Boundary Project plans cannot contain more than 1500 deliverables.
Number of fields in a view 256 Boundary A user cannot have more than 256 fields added to a view that they have defined in Project Web App.
Number of clauses in a filter for a view 50 Boundary A user cannot add a filter to a view that has more than 50 clauses in it.

 

Hope You find this usefull.

Cheers.

Advertisements

Actions

Information

69 responses

25 08 2010
Senthil Kumar

Thanks for tons of useful information

31 08 2010
SharePoint 2010: Zahlen und Fakten « SharePoint and relevant Technologies

[…] SharePoint 2010: Zahlen und Fakten 31. August 2010 Einen Kommentar hinterlassen Kommentare lesen Um eine SharePoint Installation vorzubereiten, muss man sehr viele technische Dokumente durchlesen, um eine optimale Planung für die Farm zu erreichen. Wichtig ist vor allen Dingen, gewisse Limits zu kennen, damit man hinterher nicht in Probleme läuft. Deshalb möchte ich an dieser Stelle auf einen sehr hilfreichen Blogartikel hinweisen: SharePoint 2010 Facts & Numbers […]

7 09 2012
Digital SLR Camera Bundles

Touche. Sound arguments. Keep up the good spirit.

3 10 2012
single page websites seo

Greetings! Quick question that’s entirely off topic. Do you know how to make your site mobile friendly? My site looks weird when browsing from my iphone 4. I’m trying to find
a theme or plugin that might be able to resolve this problem.

If you have any recommendations, please share.
With thanks!

4 10 2012
costumes for children

Thanks for the marvelous posting! I certainly enjoyed reading it, you may
be a great author.I will make certain to bookmark your blog and definitely
will come back down the road. I want to encourage you to continue your great
job, have a nice evening!

6 10 2012
elevator stand

Thanks for sharing your thoughts. I really appreciate your efforts and I am waiting for your further
post thanks once again.

14 10 2012
Candice

Have you ever considered publishing an ebook or guest authoring on other blogs?

I have a blog centered on the same information you discuss and would love
to have you share some stories/information. I know my readers
would enjoy your work. If you’re even remotely interested, feel free to shoot me an e-mail.

14 10 2012
Shevalini Amin

Whats up this is kinda of off topic but I was wondering if blogs use WYSIWYG editors or if you have to manually
code with HTML. I’m starting a blog soon but have no coding experience so I wanted to get guidance from someone with experience. Any help would be greatly appreciated!

21 10 2012
lose weight now

Paragraph writing is also a excitement, if you be acquainted with afterward
you can write if not it is complicated to write.

21 10 2012
Jay

Appreciation to my father who informed me regarding this webpage,
this blog is genuinely amazing.

25 10 2012
parking lotnisko

Hi there colleagues, how is all, and what you desire to
say on the topic of this piece of writing, in my view its truly amazing for me.

24 11 2012
Margo

hi there, really good to finally manage to have free time to go through this page, i have been reffered by Ulrike who is the admin for
http://oquefazerparaemagrecer.tumblr.com/, he sayd you written an wonderful post about Sharepoint 2010 Facts & Numbers Stepping stones for
crossing technological ponds and that i should take a look at it.
he has definitely been giving you plenty of visitors.

26 11 2012
Rudolph

Really great post, me and Rudolph Stanford are actually studying your weblog alot, We’re additionally producing a web site, hopefully I can find out the way to develop pages nearly as good as your own in the foreseeable future.

27 11 2012
http://www.zootoo.com

Touche. Outstanding arguments. Keep up the good work.

1 12 2012
Used Yamaha Motorbike

What’s up, always i used to check weblog posts here in the early hours in the break of day, as i enjoy to find out more and more.

5 12 2012
plan

I just like the valuable info you provide to
your articles. I’ll bookmark your weblog and test again here regularly. I am somewhat certain I will learn lots of new stuff proper right here! Best of luck for the following!

6 12 2012
apple web hosting server

I pay a quick visit every day a few blogs and blogs to read articles or reviews, but this blog presents quality based content.

9 12 2012
http://wificracker.info

I seriously enjoyed reading this page. I had been informed by Christy that your writing skill is
brilliant, she is advertising your website all the time.

12 12 2012
kolagen naturalny

Hey there! This is kind of off topic but I need some help from an
established blog. Is it very hard to set up your own blog?
I’m not very techincal but I can figure things out pretty fast. I’m thinking about making my own but I’m not sure where to begin. Do you have any points or suggestions? Thanks

19 12 2012
Derick

Hey! This is my 1st comment here so I just wanted to give a quick shout out and tell you
I genuinely enjoy reading your posts. Can you suggest any other blogs/websites/forums
that deal with the same topics? Many thanks!

22 12 2012
psychic readings

Just desire to say your article is as amazing.
The clearness in your post is simply cool and i could assume you
are an expert on this subject. Well with your permission allow me to grab your RSS feed to keep updated with forthcoming
post. Thanks a million and please carry on the gratifying work.

23 12 2012
Dani

With havin so much written content do you ever run into
any issues of plagorism or copyright violation?

My blog has a lot of completely unique content
I’ve either created myself or outsourced but it looks like a lot of it is popping it up all over the internet without my agreement. Do you know any solutions to help reduce content from being stolen? I’d certainly appreciate
it.

26 12 2012
driver Education

Thanks for your marvelous posting! I definitely enjoyed reading it, you happen to be a great
author. I will be sure to bookmark your blog and may come back at some point.

I want to encourage you to continue your great posts, have
a nice weekend!

3 01 2013
health career web

My spouse and I stumbled over here from a different website and thought I might check things out.

I like what I see so now i’m following you. Look forward to finding out about your web page for a second time.

4 01 2013
Estela

Hurrah! Finally I got a webpage from where I be able to in fact take helpful
data regarding my study and knowledge.

23 01 2013
http://ultrasoundtechnologist.webs.com

Nice post. I was checking continuously this blog and I am impressed!

Extremely useful info particularly the last part 🙂 I care for such
information much. I was seeking this certain information for a
long time. Thank you and good luck.

23 01 2013
keyword 1

This design is spectacular! You definitely know
how to keep a reader entertained. Between your wit and your videos,
I was almost moved to start my own blog (well, almost.

..HaHa!) Fantastic job. I really loved what you had to say, and more
than that, how you presented it. Too cool!

31 01 2013
ryan

I used to be recommended this blog by my cousin. I’m no longer certain whether or not this put up is written by him as nobody else understand such detailed approximately my trouble. You are amazing! Thanks!

12 02 2013
http://google.com

You really put together a number of outstanding tips with your posting, “Sharepoint 2010 Facts &
Numbers Stepping stones for crossing technological ponds”.
I will become returning to ur web-site soon enough.
Thanks ,Chadwick

18 02 2013
Chemietoilette

Its like you read my mind! You appear to grasp a
lot approximately this, like you wrote the e book in
it or something. I think that you simply could do with a few % to pressure the message house a little bit, however other than that, that is wonderful blog. An excellent read. I’ll definitely be back.

21 02 2013
Charlene

This will result in the deck feeling solid even when one is
standing over the cantilevered ends. A number of misconceptions exist in the SEO business.
There’s no stupid things like waiting months for cheques or waiting for a payment threshold, the money is yours instantly.

22 02 2013
More methods

You made some decent factors there. I seemed on the web
for the problem and located most people will associate with together with your website.

3 03 2013
Elizabeth

Wow that was odd. I just wrote an incredibly long comment but after I clicked submit my comment didn’t appear. Grrrr… well I’m
not writing all that over again. Regardless, just wanted to say superb blog!

6 03 2013
att systems

Hi, i believe that i noticed you visited my web site thus i got here to go back the favor?
.I am trying to in finding issues to enhance my site!I guess its adequate to use some
of your ideas!!

10 03 2013
url information

I usually do not write many responses, however after browsing a
bunch of comments on this page Sharepoint 2010 Facts
& Numbers | Stepping stones for crossing technological ponds.
I do have some questions for you if you do not mind.
Could it be just me or do some of the remarks come across like they are
written by brain dead folks? 😛 And, if you
are writing at additional online sites, I would like to keep up with you.

Would you make a list of the complete urls of all your shared pages like your Facebook
page, twitter feed, or linkedin profile?

11 03 2013
Søkemotoroptimalisering

It is perfect time to make some plans for the long run and it’s time to be happy. I’ve learn this post and if
I may I desire to suggest you few attention-grabbing things or suggestions.
Maybe you could write subsequent articles regarding this article.
I want to learn even more issues about it!

11 03 2013
Christine

Ahaa, its nice conversation about this paragraph at
this place at this website, I have read all that, so now me also commenting here.

11 03 2013
orlando lodging

Hello to every body, it’s my first visit of this website; this blog consists of awesome and actually good data designed for visitors.

19 03 2013
Immigration Advicers Ashford

If you wish for to grow your familiarity just keep
visiting this web site and be updated with the hottest information posted here.

20 03 2013
mouse click the next site

Heya i’m for the primary time here. I found this board and I to find It really useful & it helped me
out much. I hope to provide something again and aid others such as you aided me.

21 03 2013
Immigration Lawyer in folkstone

You’re so interesting! I don’t think I have read
something like this before. So nice to find another person with some genuine thoughts
on this subject matter. Seriously.. thank you for starting this up.
This site is one thing that’s needed on the web, someone with a bit of originality!

22 03 2013
skin disorder white patches

Generally I don’t learn article on blogs, but I wish to say that this write-up very forced me to try and do so! Your writing style has been surprised me. Thank you, very great post.

22 03 2013
language assistants visa

Hello! This is my first visit to your blog!
We are a collection of volunteers and starting a new initiative in a community in the
same niche. Your blog provided us beneficial information to work on.

You have done a marvellous job!

31 03 2013
this post

For latest news you have to go to see world-wide-web and on the web I found
this web site as a finest web page for most
up-to-date updates.

3 04 2013
business firm

I know this if off topic but I’m looking into starting my own weblog and was curious what all is required to get set up? I’m
assuming having a blog like yours would cost a pretty penny?

I’m not very web savvy so I’m not 100% certain. Any suggestions or advice would be greatly appreciated. Thanks

3 04 2013
http://cosmeticsandbeautycoupons.com

I have been browsing online more than 4 hours today, yet I never
found any interesting article like yours. It is
pretty worth enough for me. Personally, if all website owners and bloggers made good content
as you did, the web will be a lot more useful than ever before.

8 04 2013
Buy Here

This unique blog is definitely impressive, My spouse and i will re-visit repeatedly and
search for future articles or blog posts from you.

9 04 2013
decimal to binary converter

It’s actually very complex in this full of activity life to listen news on TV, so I simply use world wide web for that purpose, and get the most recent news.

10 04 2013
http://mywholesalesoap.com

A fascinating discussion is worth comment. I do believe
that you ought to publish more about this topic, it might not be a taboo subject but
typically people don’t speak about these subjects. To the next! All the best!!

10 04 2013
Jean

Your write-up has verified beneficial to me. It is very informative and that you are certainly
really knowledgeable in this location. You’ve opened my eyes to varying views on this topic with fascinating and solid content material.

10 04 2013
chat rooms give

If you are going for best contents like me, simply pay a quick visit this website every day
as it offers quality contents, thanks

10 04 2013
Leonie

The report provides established beneficial to me. It’s very helpful and you are
naturally really experienced in this field.

You get opened up our face to numerous thoughts about this specific subject together with intriguing,
notable and strong articles.

11 04 2013
Visitenkarten Drucken Und Erstellen

Hurrah, that’s what I was exploring for, what a stuff! present here at this webpage, thanks admin of this web page.

13 04 2013
best wine cooler

Valuable information. Fortunate me I discovered your website by chance, and I
am shocked why this twist of fate did not came about in advance!
I bookmarked it.

16 04 2013
Kindergeburtstag mannheim

I’m gone to convey my little brother, that he should also visit this weblog on regular basis to get updated from most up-to-date information.

17 04 2013
wright brothers

Hi, after reading this remarkable paragraph i am
too cheerful to share my knowledge here with friends.

17 04 2013
brown bags

Nice post. I learn something new and challenging on websites I stumbleupon every day.

It’s always helpful to read content from other writers and use something from other websites.

18 04 2013
Guess France

I do not know whether it’s just me or if perhaps everybody else encountering issues with your site. It seems like some of the written text in your content are running off the screen. Can somebody else please provide feedback and let me know if this is happening to them as well? This could be a issue with my web browser because I’ve
had this happen before. Cheers

18 04 2013
St Andrews Airport Transfer

This paragraph is genuinely a good one it assists new web visitors, who are wishing
for blogging.

21 04 2013
nagelpilz erkennen und lindern

Great post. I was checking constantly this blog and I’m impressed! Very helpful info specifically the last part 🙂 I care for such info a lot. I was looking for this certain info for a long time. Thank you and best of luck.

22 04 2013
ordering online takeaway

There is certainly a lot to find out about this topic. I love all the points you made.

22 04 2013
cleaning business

Hi there! This post could not be written much better!
Going through this article reminds me of my previous roommate!
He constantly kept talking about this. I’ll send this post to him. Pretty sure he’s going
to have a great read. Thanks for sharing!

22 04 2013
http://blogs.Albawaba.com/

excellent submit, very informative. I wonder why the opposite experts of this sector don’t understand this. You must continue your writing. I’m sure, you’ve a great readers’ base already!

22 04 2013
Www2.Ufpa.Br

Great web site you have got here.. It’s difficult to find excellent writing like yours these days. I seriously appreciate people like you! Take care!!

23 04 2013
http://Www.E-catworld.com/groups/nagelpilz-medikament-rezeptfrei/

Hey there! I simply want to offer you a big thumbs up for your excellent information
you have got right here on this post. I’ll be returning to your web site for more soon.

23 04 2013
Die Abnehm Lösung

I am really impressed with your writing talents and also with the format in your weblog.
Is this a paid subject matter or did you modify it your
self? Either way keep up the nice high quality writing, it
is uncommon to look a great blog like this one nowadays.
.

23 04 2013
Bauchmuskeltraining

Good info. Lucky me I came across your site by accident (stumbleupon).
I have saved it for later!

23 04 2013
Fettverbrennungsofen

Hi, i feel that i noticed you visited my blog so i came
to go back the desire?.I am attempting to find issues to
improve my website!I guess its good enough to use a few of your ideas!
!

30 05 2013
irritable bowel syndrome management

This post will help the internet people for building up new weblog or
even a weblog from start to end.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




%d bloggers like this: