
Posted on October 11, 2010 by Kelly Rusk in SharePoint
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.Note: 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.Note: You cannot have both the maximum number of term sets and the maximum number of terms simultaneously in a term store. |
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23





Tags: 
One Response
[...] Know Your Limits: Capacity Planning in SharePoint 2010 | Concurrency Blog (tags: sharepoint architecture sql) Like this:LikeBe the first to like this post. [...]