Compare The SharePoint 2016 Content Database Limits With Other SharePoint Versions

Introduction

In this article, I will compare the limits of SharePoint 2016 Content Database with other SharePoint versions.

Boundaries, Thresholds and Supported limits

Before we getting started, you should first know what are the types of Limit.

  • Boundaries: Static limits that cannot be exceeded by design.
  • Thresholds: Configurable limits that can be exceeded to accommodate specific requirements.
  • Supported limits: Configurable limits that have been set by default to a tested value.
Content Database Limits for SharePoint

The below table lists the recommended guidelines for Content Database in SharePoint 2016,2013,2010,2007.

Limits/VersionLimit TypeSharePoint 07 SharePoint 10SharePoint 13SharePoint 2016
Content Database Per farmSupportedxx500500
Content Database Per Web ApplicationSupported100300xx
Site Collection Per Content DatabaseSupported50,0005,000 Max10,000 Max10,000 Max
  2,000 recommended2,500 non-Personal site collections and 7,500 Personal Sites, or 10,000 Personal Sites aloneStrongly recommend limiting the number of site collections in a content database to 5,000. However, up to 10,000 site collections in a database are supported.
Content Database Size (General Usage scenario)Supported100 GB200 GB200 GB200 GB up to 1TB
Content Database Size (All Usage scenario)Supported> 100 GB4 TB4 TB4 TB
Content database size (document archive scenario)SupportedxNo explicit content database limitNo explicit content database limitNo explicit content database limit
Content Database ItemsSupported60 Million items including documents and list items60 Million items including documents and list items60 Million items including documents and list items60 Million items including documents and list items
Remote BLOB StorageBoundaryx< 20 millisecondsTime to first byte of any response from the NAS should remain within 40 milliseconds 95% of the time.Time to first byte of any response from the NAS should remain within 40 milliseconds 95% of the time.

Note - X indicates this information is not mentioned in TechNet.

Conclusion

In this article, I've compared the SharePoint 2016 Content Database limits with SharePoint 2013 / 2010 / 2007.

Reference