SharePoint 2019 Limitations

In this post, we’re gonna explore the SharePoint 2019 Limitations compared to other SharePoint versions (SharePoint 2016, SharePoint 2013, SharePoint 2010, and SharePoint 2007).

You might also like to check PowerShell Script: SharePoint Farm Scan Report

---

SharePoint 2019 Limitations

Before we getting started, let’s first know the key difference between

• Boundary,
• Threshold,
• Supported Limits.

Boundary in SharePoint

Boundary is a static limit that cannot be exceeded by design.

SharePoint Boundary Example

In SharePoint 2019, the built-in absolute value for file size is 15 GB. This value can’t be configured to store documents > 15 GB.

Threshold in SharePoint

Threshold is a configurable default value limit that can be exceeded only in certain circumstances to match specific requirements.

SharePoint Threshold Example

In SharePoint 2019, the default file size threshold is 2GB which can be changed up to 15 GB as a boundary limit.

Changing the threshold default value may affect the performance of the farm or other unexpected result. Therefore, you should change the threshold default value only in certain circumstances.

Supported limit in SharePoint

Supported limit is a configurable limit that has been set by default to a tested value.

SharePoint Limit Example

The number of SharePoint Group per Site Collection (10,000) is an example of the supported limit in SharePoint 2019.

You can change many supported limits in SharePoint Server 2019. meanwhile, you should be aware of changing the limit may affect other parts of the farm and the farm performance in general.

---

SharePoint 2019 Web Application Limit

In this section, we will list the Web Application Limit SharePoint 2019 compared to SharePoint 2016, SharePoint 2013, SharePoint 2010, and SharePoint 2007.

• Web Application limit.
• Zone limit.
• A managed path for host-named site collections limit.
• A managed path for path-based site collections limit.
• Solution cache size limit.

Web Application Limit

The below table lists the SharePoint 2019 web application limit per farm compared to other SharePoint versions.

Limit Type	SharePoint 2019	SharePoint 2016	2013	2010	2007
Supported	20	20	20	X	X

It’s highly recommended to create host-named site collections instead of creating multiple web applications.

Zone Limit

The below table lists the SharePoint Zone limit per web application.

Limit Type	SharePoint 2019	SharePoint 2016	2013	2010	2007
Boundary	5	5	5	5	5 per farm

The zone absolute value in SharePoint is 5:

• Default,
• Intranet,
• Extranet,
• Internet,
• Custom.

You can’t add any additional zones in SharePoint

Managed path for host-named site collections

The below table lists the Managed path for host-named site collections limit per farm.

Limit Type	SharePoint 2019	SharePoint 2016	2013	2010	2007
Supported	20	20	20	X	X

You can apply the created managed path for host-named site collection in any web application within the farm

Managed path for path-based site collections

The below table lists the Managed path for path-based site collections limit per web application.

Limit Type	SharePoint 2019	SharePoint 2016	2013	2010	2007
Supported	20	20	20	20	20

Adding more that 20 managed paths per web application will affect the farm perfromance through loading on the web server for each request.

Solution Cache Size Limit

The below table lists the SharePoint Solution cache size limit per web application.

Limit Type	SharePoint 2019	SharePoint 2016	2013	2010	2007
Supported	300 MB	300 MB	300 MB	300 MB	X

The solution cache is very helpful to retrieve InfoPath Forms from the cache instead of disk. if this limit exceeded it will retrieve from the disk and this is, of course, will affect the performance.

Check how to configure the InfoPath cache solution size at Set-SPInfoPathFormsService.

---

SharePoint 2019 Application Pool Limit

In this section, we will list the Application Pool Limit for SharePoint 2019 compared to SharePoint 2016, SharePoint 2013, SharePoint 2010, and SharePoint 2007.

Application Pool Limits per Web Server on the Farm

The below table lists the SharePoint Application Pool Limits for Web Server on the Farm.

Limit Type	SharePoint 2019	SharePoint 2016	2013	2010	2007
Threshold	10	10	10	10	8

This limit mainly depends on the Server Hardware specifications (Memory and CPU), you can determine the max number of Application Pools per web server on the farm based on the installed memory where a single highly active Application Pool can utilize more than 10 GB.

---

SharePoint 2019 Content Database Limit

In this section, we will list the Content Database Limit for SharePoint 2019 compared to SharePoint 2016, SharePoint 2013, SharePoint 2010, and SharePoint 2007.

• Content database per farm limit.
• Content database size limit.
• Content database items limit.

Content Databases Limit Per Farm

The below table lists the SharePoint Content Databases Per Farm Limit.

Limit Type	SharePoint 2019	SharePoint 2016	2013	2010	2007
Supported	500	500	500	X	X

SharePoint Server 2019 supports 100TB of data for all content databases per farm.

If you have large number of content databases within the farm, so It’s highly recommended to use PowerShell to manage web applications.

You might also like to read Get All Content Databases Per Farm Using PowerShell

Content Database Size Limit

The below table lists the SharePoint Content Database Size Limit.

General Usage

Limit Type	SharePoint 2019	SharePoint 2016	2013	2010	2007
Supported	200GB~1TB	200GB~1TB	200GB	200GB	100GB

• It’s highly recommended to limit the content database size to 200GB in general usage scenarios.
• To avoid large content database size, you should deploy multiple content databases per web application.
• It’s recommended to limit the site collection size to 100GB within a content database.
• It’s very difficult and time-consuming to operate (backup – restore -upgrade) a large content database size.

All Usage

Limit Type	SharePoint 2019	SharePoint 2016	2013	2010	2007
Supported	4TB	4TB	4TB	4TB	>100GB

• There are important requirements for the content database with 4TB size like:
  • specific hardware specifications.
  • performing high availability and disaster recovery plans.
  • performing performance testing.
  • Thinking about the operations tasks.
• Document archiving scenarios depends on “Document Center” and “Record Center” site templates.
• Expect the document archiving scenarios, It’s not recommended to use a content database with a size larger than 4TB.

Content Databases Items Limit

The max number of items per content database including the list items and documents.

Limit Type	SharePoint 2019	SharePoint 2016	2013	2010	2007
Supported	60M	60M	60M	60M	X

To use more than 60M items per content database, you must deploy multiple content databases.

You may also like to read Comparing Content Database limits in SharePoint 2016 with SharePoint 2013 / 2010 / 2007.

---

SharePoint 2019 Site Collection Limit

In this section, we will list the Site Collection Limit for SharePoint 2019 compared to SharePoint 2016, SharePoint 2013, SharePoint 2010, and SharePoint 2007.

• Site collections per content database limit.
• Site collections per farm limit.
• Web site per site collection limit.
• Site collection size limit.
• Device channels per publishing site collection limit.

You might also like to read Get All Site Collections and SubSites Per Farm Using PowerShell

Site Collections Per Content Database Limit

The below table lists the SharePoint Site Collections Per Content Database Limit.

Limit Type	SharePoint 2019	SharePoint 2016	2013	2010	2007
Supported	10,000	10,000	10,000	5,000	50,000

• In SharePoint 2010, the recommended site collections per content database are 2000 and the maximum is 5000.
• In SharePoint 2019 / 2016 / 2013,
  • Although the supported site collections are 10,000, it’s strongly recommended to limit the number of site collections per content database to 5000.
  • The max number of site collections per content database is 2500 for non-personal site collections and 7500 for personal site collections.

Larger site collections per content database lead to slowness and longer downtime during operation tasks like backup, restore and upgrade.

You may also like Comparing Site Collection limits in SharePoint 2016 with SharePoint 2013 / 2010 / 2007.

Site Collections Per Farm Limit

The below table lists the SharePoint Site Collections Per Farm Limit.

Limit Type	SharePoint 2019	SharePoint 2016	2013	2010	2007
Supported	750,000	750,000	750,000	X	X

The maximum recommended number of site collections per farm is 500,000 Personal Sites plus 250,000 for all other site templates.

Web Site Per Site Collection Limit

The below table lists the SharePoint Web Site Per Site Collection Limit.

Limit Type	SharePoint 2019	2016	2013	2010	2007
Supported	250,000	250,000	250,000	250,000	250,000

• The number of web sites per site collection is 250,000 and it’s the same number of web sites per farm.
• The number of personal web sites per farm is 500,000.
• The recommended number of web sites per site collection is 2000.

More than 2000 web site per site collection may raise the following issues:

• Deleting or creating a new web site will affect the availability of other web sites in the same site collection.
• Facing a performance issue during:
  • Updating the farm,
  • Adding a new server to the farm,
  • Running the SharePoint Configuration wizard.

It’s recommended to deploy multiple site collections If you are planning to create more than 2000 web sites per site collection. In this case, the max site collections number that you can create per farm is 125 site collections. (125 site collection * 2000 web site) = 250,000 web sites and this the supported number of web sites per farm.

Site Collection Size Limit

The Site collection size is the maximum size of the content database. however, in general, it strongly recommends limiting the size of site collections to 100 GB.

Limit Type	SharePoint 2019	2016	2013	2010	2007
Supported	100GB	100GB	100GB	100GB	100GB

• SharePoint site collection backup and restore is
  • NOT supported for a site collection size larger than 100 GB.
  • Only supported for a site collection with 100 GB size.
• The full content database backup must be taken for larger site collections.
• If you have a single content database with multiple site collections larger than 100 GB, the operation tasks like backup and restore will take a long time and maybe failed.

Device Channels Per Publishing Site Collection Limit

The below table lists the Device Channels Per Publishing Site Collection Limit.

Limit Type	SharePoint 2019	2016	2013	2010	2007
Boundary	10	10	10	X	X

Read more about Device Channels at SharePoint Design Manager device channels.

---

SharePoint 2019 List and library Limits

In this section, we will list the List and Library Limits for SharePoint 2019 compared to SharePoint 2016, SharePoint 2013, SharePoint 2010, and SharePoint 2007.

• List row size limit.
• File size limit.
• Documents limit.
• Major versions limit.
• Minor versions limit.
• Items limit.
• Bulk operations limit.
• List view lookup threshold.
• List view lookup threshold limit.
• List view lookup threshold.
• Subsite limit.
• List limit.
• Coauthoring limit.
• Security scope limit.

You may also like Comparing List and Library limits in SharePoint 2016 with SharePoint 2013 / 2010 / 2007.

List Row Size Limit

The boundary list row size is 8,000 bytes:

• 300 bytes are reserved.
• 7700 bytes for end-user columns.

Limit Type	SharePoint 2019	2016	2013	2010	2007
Boundary	8,000 bytes per row	8,000	8,000	8,000	X

File Size Limit

The default file size is 2GB. However, large files size can affect farm performance.

Limit Type	SharePoint 2019	2016	2013	2010	2007
Boundary	15GB	10GB	2GB	2GB	50MB~2GB

Documents Limit

The supported documents number per document library is 30,000,000 documents.

Limit Type	SharePoint 2019	2016	2013	2010	2007
Supported	30M	30M	30M	30M	5M

Items Limit

The supported items number per list is 30,000,000 items.

Limit Type	SharePoint 2019	2016	2013	2010	2007
Supported	30M	30M	30M	30M	5M

Major Versions Limit

Limit Type	SharePoint 2019	2016	2013	2010	2007
Supported	40,000	40,000	40,000	40,000	X

Basic file operations like open, save, delete and view version history may be failed if the number of major versions exceed.

Minor Versions Limit

Limit Type	SharePoint 2019	2016	2013	2010	2007
Boundary	511	511	511	X	X

Bulk Operations Limit

The maximum selected item number for bulk operations through the GUI is 100 items.

Limit Type	SharePoint 2019	2016	2013	2010	2007
Boundary	100	100	100	100	X

List View Lookup Threshold

ListView Lookup Threshold limits the number of Lookups, Person/Group or Workflow Status fields joins that are included in the query.

List View Lookup Threshold Example

If you have a view that displays 4 lookup columns, and filters on another 5 distinct lookup columns, so it uses 9 lookups.

In this case, the ListView Lookup Threshold is set to 8, the operation will be blocked and cause an error.

Limit Type	SharePoint 2019	2016	2013	2010	2007
Threshold	12 joins per each query	12	12	10	X

It’s not recommended to increase the ListView Lookup Threshold to more than 8 joins.

List view threshold

The list view threshold is the number of shown items per each view.

Limit Type	SharePoint 2019	2016	2013	2010	2007
Threshold	Greater than 5000	> 5000	5000	5000	2000

• For good performance, by default, the ListView Threshold is set to approximately 5000 items.
• The List view threshold for auditors and administrators is 20,000 items.
• The threshold is 20,000 by default. in case, you added or removed a column index.
• The threshold is 100,000 by default. in case, you deleted a list or folder or renaming a folder within the same library.

For more details about working with the ListView Threshold limit, please, check How to Manage large lists and libraries in SharePoint

Subsite View Per Site

The number of subsites shown in the “All Site Content page” and other similar pages.

Limit Type	SharePoint 2019	2016	2013	2010	2007
Threshold	2000	2000	2000	2000	X

For good performance, the subsites should not be more than 2000 subsite per site view.

List Per Web Site

Limit Type	SharePoint 2019	2016	2013	2010	2007
Threshold	2000	2000	2000	2000	X

Coauthoring

The coauthoring boundary is 99 editors, the recommended number of concurrent editors is 10.

Limit Type	SharePoint 2019	2016	2013	2010	2007
Threshold	10	10	10	10	X

• If there are 99 co-authors who have a single document opened for concurrent editing, each successive user sees a “File in use” error, and can only open a read-only copy.
• More than 10 co-editors will lead to a gradually degraded user experience with more conflicts, and users might have to go through more iterations to successfully upload their changes to the server.

Security scope

The unique security scopes per list cannot exceed 50,000.

Limit Type	SharePoint 2019	2016	2013	2010	2007
Threshold	50,000	50,000	50,000	50,000	X

• It’s recommended to limit unique scopes to 5,000 per list.
• Use as few unique permissions as possible for large lists.
• Additional SQL Server round trips take place when the unique security scopes exceed the value of the list view threshold.

---

ShaSharePoint 2019 Limitations: Column Limit

In this section, we will list the Column Limits for SharePoint 2019, and it’s the same column limits for SharePoint 2016, SharePoint 2013, SharePoint 2010, and SharePoint 2007.

The below table lists the Threshold Column Type Size in Bytes.

Limit	Maximum # columns	Size per column
Single line of text	255	30 bytes
Multiple Lines of Text	350	22 bytes
Choice	255	30 bytes
Choice (multiple selection)	350	22 bytes
Number	550	14 bytes
Currency	550	14 bytes
Date and Time	55	14 bytes
Lookup	750	10 bytes
Yes / No	1000	7 bytes
Person or group	750	10 bytes
Hyperlink or picture	127	60 bytes
Calculated	255	30 bytes
GUID	350	22 bytes
Integer	750	10 bytes
Managed metadata	190	60 bytes for the first, 40 bytes for each subsequent
Geolocation	2	30 bytes

The sum of all columns in a SharePoint list cannot exceed 8,000 bytes per each row.

---

SharePoint 2019 Limitations: Page Limits

In this section, we will list the Web Part per Wiki or Web Part page Limits for SharePoint 2019 compared to SharePoint 2016, SharePoint 2013, SharePoint 2010, and SharePoint 2007.

Limit Type	SharePoint 2019	2016	2013	2010	2007
Threshold	25	25	25	25	X

---

SharePoint 2019 Limitations: Security Limits

In this section, we will list the Security Limits for SharePoint 2019 compared to SharePoint 2016, SharePoint 2013, SharePoint 2010, and SharePoint 2007.

• SharePoint groups limit.
• Users in a site collection limit.
• Users in a SharePoint group limit.
• Number of SharePoint groups a user can belong to.

SharePoint Groups Limit

The below table lists the number of SharePoint Groups per Site Collection.

Limit Type	SharePoint 2019	2016	2013	2010	2007
Supported	10,000	10,000	10,000	X	X

SharePoint Users Limit

The below table lists the number of SharePoint Users per Site Collection.

Limit Type	SharePoint 2019	2016	2013	2010	2007
Supported	2M	2M	2M	2M	X

Users in a SharePoint Group Limit

The below table lists the number of users in a SharePoint group limit.

Limit Type	SharePoint 2019	2016	2013	2010	2007
Supported	5,000	5,000	5,000	5,000	X

Number of SharePoint groups a user can belong to.

The below table lists the number of SharePoint groups a user can belong to limit.

Limit Type	SharePoint 2019	2016	2013	2010	2007
Supported	5,000	5,000	5,000	5,000	X

---

SharePoint 2019 Search Limits

In this section, we will list the below Search Limits for SharePoint 2019.

• Topology limits.
• Item size limits.
• Dictionary limits.
• Schema limits.
• Crawl limits.
• Query and result limits.
• Ranking limits.
• Index limits.

Topology Limits

The below table lists the SharePoint Search Topology Limits.

Limit	Maximum value	Limit type
Analytics processing components	6 per Search service application; 1 per server	Supported
Analytics reporting databases	4 per Search service application	Threshold
Link databases	4 per Search service application	Supported
Crawl components	16 per Search service application; 1 per server	Supported
Index components	60 per Search service application; 4 per server	Supported
Index partitions	25 per Search service application	Supported
Index replicas	3 per index partition	Supported
Content processing components	1 per server	Supported
Query processing components	1 per server	Supported
Search components	64 per Search service application	Supported
Search service applications	20 per farm	Supported
Content sources	500 per Search service application	Boundary

Item Size Limits

The below table lists the SharePoint Search Item Size Limits.

Limit	Maximum value	Limit type
Document size crawl component can download	64 MB (3 MB for Excel documents)	Threshold
Parsed content size	2 million characters	Boundary
Characters produced by the word breaker	1,000,000	Boundary
Indexed managed property size	512 KB per searchable/queryable managed property	Threshold
Retrievable managed property size	16 KB per managed property	Threshold
Sortable and refinable managed property size	16 KB per managed property	Boundary
Token size	Variable	Boundary
Unique indexed tokens per mnaged property	1,000,000	Threshold
Distinct users or AD security groups having access to an item	1,000,000	Threshold

Dictionary Limits

The below table lists the SharePoint Search Dictionary Limits.

Limit	Maximum value	Limit type
Number of entries in a thesaurus	1 million	Supported
Number of entries in a custom entity extraction dictionary	1 million	Supported
Number of entries in a custom search dictionary	5,000 terms per tenant	Boundary

Schema Limits

The below table lists the SharePoint Search Schema Limits.

Limit	Maximum value	Limit type
Crawled properties	500,000 per Search service application	Supported
Managed properties	50,000 per Search service application	Supported
Managed property mappings	100 per managed property	Supported
Values per managed property	1,000	Boundary
Metadata properties recognized	100,000 per crawled item	Supported

Crawl Limits

The below table lists the SharePoint Search Crawl Limits.

Limit	Maximum value	Limit type
Start addresses	500 per content source	Supported
Length of machine host name	15 characters	Threshold
Crawl databases	15 per Search service application	Supported

Query and Result Limits

The below table lists the SharePoint Search Query and Result Limits.

Limit	Maximum value	Limit type
Text length for queries using Keyword Query Language	4 KB (4,096 characters)	Supported
Text length for queries on the SharePoint home page	16 KB (16,384 characters)	Supported
Number of rows in a result set	500 rows	Supported
Results removal	No limit	Supported
Search alert quota	100,000 alerts per Search service application	Supported

Ranking Limits

The below table lists the SharePoint Search Ranking Limits.

Limit	Maximum value	Limit type
Ranking models	1,000 per tenant	Boundary
Unique contexts used for ranking	15 unique contexts per rank model	Boundary
Authoritative pages	1 top level and minimal second and third level pages per Search service application	Supported

Index Limits

The below table lists the SharePoint Search Index Limits.

Limit	Maximum value	Limit type
Unique terms in the index	2^31 (>2 billion terms)	Boundary
User defined full text indexes	10	Boundary
Indexed items	20 million per index partition	Supported

---

SharePoint 2019 User Profile Service Limits

The below table lists the SharePoint User Profile Service Limits.

Limit	Maximum value	Limit type
User profiles	2,000,000 per service application	Supported
Social tags, notes and ratings	500,000,000 per social database	Supported

SharePoint 2019 Limitations: Content deployment Limits

The below table lists the SharePoint Content Deployment Limits.

Limit	Maximum value	Limit type
Content deployment jobs running on different paths	20	Supported

---

SharePoint 2019 Limitations: Blog Limits

The below table lists the SharePoint Blog Limits.

Limit	Maximum value	Limit type
Blog posts	5,000 per site	Supported
Comments	1,000 per post	Supported

---

SharePoint 2019 Limitations: Business Connectivity Services Limits

The below table lists the SharePoint BCS Limits.

Limit	Maximum value	Limit type
ECT (in-memory)	5,000 per web server (per tenant)	Boundary
External system connections	500 per web server	Boundary
Database items returned per request	2,000 per database connector	Threshold
Response latency	600 seconds	Threshold
Service response size	150,000,000 bytes	Threshold
Filter Descriptor (in-store)	200 per ECT method	Boundary
ECT Identifier (in-store)	20 per ECT	Boundary
Database Item	1,000,000 per request	Threshold

---

SharePoint 2019 Limitations: Workflow Limits

The below table lists the SharePoint Workflow Limitations.

Limit	Maximum value	Limit type
Workflow postpone threshold	15	Threshold
Workflow timer batch size	100	Threshold
Workflow associations	100 per list	Supported
List items or documents that can be bulk created or uploaded to start workflow instances	5,000 items	Supported
Published workflow definitions per web site	1,000 per web site	Supported
Total workflow associations per site	1,799 per site	Boundary
Maximum workflow definition (xaml) size	5,120 KB	Boundary
Maximum depth of a workflow sub-step in xaml (workflow complexity)	121 levels	Boundary
Workflow instance activations per second per web server	6 per second	Threshold
Rest calls from SharePoint workflow per second per web server	60 per second	Supported
Workflow variable value size	256 KB	Boundary
Maximum list size for workflow lookups to non-indexed fields	5,000 items per list view	Threshold
Maximum list size for auto-start workflow associations	10 million items per list	Supported

---

SharePoint 2019 Limitations: Managed Metadata Term Store Limits

The below table lists the SharePoint Managed Metadata Term Store Limits.

Limit	Maximum value	Limit type
Maximum number of levels of nested terms in a term store	7	Supported
Maximum number of term sets in a term store	1,000	Supported
Maximum number of terms in a term set	30,000	Supported
Total number of items in a term store	1,000,000	Supported
Number of Variation Labels	209 per term store	Supported
Number of terms in managed navigation term set	2,000	Supported
Number of direct child-terms in managed navigation term set	300	Supported

---

SharePoint 2019 Limitations: Visio Services Limits

The below table lists the SharePoint Visio Services Limits.

Limit	Maximum value	Limit type
File size of Visio web drawings	50 MB	Threshold
Visio web drawing recalculation time-out	120 seconds	Threshold
Visio Services minimum cache age (data connected diagrams)	Minimum cache age: 0 to 24hrs	Threshold
Visio Services maximum cache age (non-data connected diagrams)	Maximum cache age: 0 to 24hrs	Threshold

---

SharePoint 2019 Limitations: PerformancePoint Services Limits

The below table lists the SharePoint Performance Services Limits.

Limit	Maximum value	Limit type
Cells	1,000,000 per query on Excel Services data source	Boundary
Columns and rows	15 columns by 60,000 rows	Threshold
Query on a SharePoint list	15 columns by 5,000 rows	Supported
Query on a SQL Server data source	15 columns by 20,000 rows	Supported

---

SharePoint 2019 Limitations: Word Automation Services Limits

The below table lists the Word Automation Services Limits.

Limit	Maximum value	Limit type
Input file Size	512 MB	Boundary
Frequency with which to start conversions (minutes)	1 minute (recommended) 15 minutes (default) 59 minutes (boundary)	Threshold
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
Conversion job size	100,000 conversion items	Supported
Total active conversion processes	N-1, where N is the number of cores on each application server	Threshold
Word Automation Services database size	2 million conversion items	Supported

---

SharePoint 2019 Limitations: Machine Translation Service Limits

The below table lists the SharePoint Machine Translation Service Limits.

Limit	Maximum value	Limit type
Input file size for binary files	524,288 KB per file	Threshold
Input file size for text files	15,360 KB per file	Threshold
Maximum character count for Microsoft Word Documents	10,000,000 per document	Threshold
Total concurrent translation processes	5	Threshold
Delay between translations	59 minutes	Threshold
Number of translations per translation process	1,000 per process	Threshold
Maximum concurrent translation requests	300	Threshold
Files per translation job	100,000 files	Supported
Machine Translation Service database size	1,000,000 files	Supported

---

SharePoint 2019 Limitations: Office Online Service Limits

The below table lists the SharePoint Office Online Service Limits.

Limit	Maximum value	Limit type
Cache size	100 GB	Threshold
Renders	One per document per second per CPU core per application server (maximum eight cores)	Boundary
OneNote concurrent merge operations	8 per document	Threshold

---

SharePoint 2019 Limitations: Project Server Limits

The below table lists the Project Server Limits.

Limit	Maximum value	Limit type
End of project time	Date: 12/31/2149	Boundary
Deliverables per project plan	1,500 deliverables	Boundary
Number of fields in a view	256	Boundary
Number of clauses in a filter for a view	50	Boundary

---

SharePoint 2019 Limitations: SharePoint Apps Limits

The below table lists the SharePoint Apps Limits.

Limit	Maximum value	Limit type
Maximum Access/SharePoint App Package size	100 Mb	Boundary
Maximum Access app database storage size in SQL Azure	1 Gb	Boundary
Apps displayed in Manage Licenses page	2,000	Boundary
Number of app licenses per tenant	1,000,000	Supported
Number of apps displayed in the Add an App page	240	Boundary
Number of managers per app license	30	Boundary
Number of app licenses assigned to a user viewable by that user	2,000	Boundary
Number of apps in the corporate catalog viewable by a single user	500	Boundary

---

SharePoint 2019 Limitations: Distributed cache service limits

The below table lists the SharePoint Distributed Cache Service Limits.

Limit	Maximum value	Limit type
Number of followable entities (users, documents, sites and hashtags) per cache host	400,000	Supported
Number of cache hosts in a cluster	16	Boundary
Maximum amount of memory dedicated to a cache host	16GB	Boundary

---

SharePoint 2019 Limitations: Miscellaneous limits

Limit	Maximum value	Limit type
Number of User agent substrings per device channel	150	Boundary
Number of SharePoint sources per EDiscovery case	100	Boundary
Number of Exchange sources (mailboxes) per EDiscovery case	1,500	Boundary
Maximum size of EDiscovery Query	16K characters or 500 keywords	Boundary

---

Applied To

• SharePoint 2019.
• SharePoint 2016.

Conclusion

In conclusion, we have discussed SharePoint 2019 limitations compared to SharePoint 2016 limitations, SharePoint 2013 limitations, SharePoint 2010 limitations, and SharePoint 2007 limitations.

We have also explored the below SharePoint 2019 limits in details:

• Web Application Limits.
• Application Pool Limits.
• Content Database Limits.
• Site Collection Limits.
• List and library Limits.
• Column Limits.
• Page Limits.
• Security Limits.
• Search Limits.
• User Profile Service Limits.
• Content deployment Limits.
• Blog Limits.
• Business Connectivity Services Limits.
• Workflow Limits.
• Managed Metadata Term Store Limits.
• Visio Services Limits.
• PerformancePoint Services Limits.
• Word Automation Services Limits.
• Machine Translation Service Limits.
• Office Online Service Limits.
• Project Server Limits.
• SharePoint Apps Limits.
• Distributed cache service Limits.
• Miscellaneous Limits.

Reference

• Limits for SharePoint Servers 2016 and 2019.

Download

• PowerShell Script: SharePoint Farm Scan Report.
• PowerShell Script: Get All Web Applications Per Farm.
• PowerShell Script: Get All Content Databases Per Farm.
• PowerShell Script: Get All Site Collections and SubSites Per Farm.

Have a Question?

If you have any related questions, please don’t hesitate to Ask it at deBUG.to Community.