How big can my SharePoint 2010 installation be?

Posted on Dot net Slackers See other posts from Dot net Slackers
Published on Sun, 16 May 2010 00:00:00 GMT Indexed on 2010/05/16 19:01 UTC
Read the original article Hit count: 544

Filed under:
Ad:: SharePoint 2007 Training in .NET 3.5 technologies (more information). This feed URL has been discontinued. Please update your reader's URL to : http://feeds.feedburner.com/winsmarts Read full article .... ...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.



Email this Article

© Dot net Slackers or respective owner

How big can my SharePoint 2010 installation be?

Posted by Sahil Malik on Win Smarts See other posts from Win Smarts or by Sahil Malik
Published on Sun, 16 May 2010 14:18:46 GMT Indexed on 2010/05/16 18:41 UTC
Read the original article Hit count: 544

Filed under:

Ad:: SharePoint 2007 Training in .NET 3.5 technologies (more information).

3 years ago, I had published “How big can my SharePoint 2007 installation be?”

Well, SharePoint 2010 has significant under the covers improvements. So, how big can your SharePoint 2010 installation be?

There are three kinds of limits you should know about

  • Hard limits that cannot be exceeded by design.
  • Configurable that are, well configurable – but the default values are set for a pretty good reason, so if you need to tweak, plan and understand before you tweak.
  • Soft limits, you can exceed them, but it is not recommended that you do.

Before you read any of the limits, read these two important disclaimers -

1. The limit depends on what you’re doing. So, don’t take the below as gospel, the reality depends on your situation.
2. There are many additional considerations in planning your SharePoint solution scalability and performance, besides just the below.

So with those in mind, here goes.

 

Hard Limits -

Zones per web app

5

RBS NAS performance

Time to first byte of any response from NAS must be less than 20 milliseconds

List row size

8000 bytes driven by how SP stores list items internally

Max file size

2GB (default is 50MB, configurable). RBS does not increase this limit.

Search metadata properties

10,000 per item crawled (pretty damn high, you’ll never need to worry about it).

Max # of concurrent in-memory enterprise content types

5000 per web server, per tenant

Max # of external system connections

500 per web server

PerformancePoint services using Excel services as a datasource

No single query can fetch more than 1 million excel cells

Office Web Apps Renders

One doc per second, per CPU core, per Application server, limited to a maximum of 8 cores.

 

Configurable Limits -

Row Size Limit

6, configurable via SPWebApplication.MaxListItemRowStorage property

List view lookup

8 join operations per query

Max number of list items that a single operation can process at one time in normal hours

5000

Configurable via SPWebApplication.MaxItemsPerThrottledOperation

 

Also you get a warning at 3000, which is configurable via

SPWebApplication.MaxItemsPerThrottledOperationWarningLevel

 

In addition, throttle overrides can be requested, throttle overrides can be disabled, and time windows can be set when throttle is disabled.

Max number of list items for administrators that a single operation can process at one time in normal hours

20000

Configurable via SPWebApplication.MaxItemsPerThrottledOperationOverride

Enumerating subsites

2000

Word and Powerpoint co-authoring simultaneous editors

10 (Hard limit is 99).

# of webparts on a page

25

Search Crawl DBs per search service app

10

Items per crawl db

25 million

Search Keywords

200 per site collection. There is a max limit of 5000, which can then be modified by editing the web.config/client.config.

Concurrent # of workflows on a content db

15. Workflows running in the timer service are not counted in this limit. Further workflows are queued. Can be configured via the Set-SPFarmConfig powershell commandlet.

Number of events picked by the workflow timer job and delivered to workflows

100. You can increase this limit by running additional instances of the workflow timer service.

Visio services file size

50MB

Visio web drawing recalculation timeout

120 seconds

Configurable via – Powershell commandlet Set-SPVisioPerformance

Visio services minimum and maximum cache age for data connected diagrams

0 to 24 hours. Default is 60 minutes.

Configurable via – Powershell commandlet Set-SPVisioPerformance

 

Soft Limits -

Content Databases

300 per web app

Application Pools 10 per web server

Managed Paths

20 per web app

Content Database Size

200GB per Content DB

Size of 1 site collection

100GB

# of sites in a site collection

250,000

Documents in a library

30 Million, with nesting. Depends heavily on type and usage and size of documents.

Items

30 million. Depends heavily on usage of items.

SPGroups one SPUser can be in

5000

Users in a site collection

2 million, depends on UI, nesting, containers and underlying user store

AD Principals in a SPGroup

5000

SPGroups in a site collection

10000

Search Service Instances

20

Indexed Items in Search

100 million

Crawl Log entries

100 million

Search Alerts

1 million per search application

Search Crawled Properties

1/2 million

URL removals in search

100 removals per operation

User Profiles

2 million per service application

Social Tags

500 million per social database


Comment on the article ....


© Win Smarts or respective owner

Related posts about SharePoint 2010