SharePoint 2016 Content Database Limits

Content Database limits in SharePoint 2016

In this post, we’ll compare SharePoint 2016 Content Database limits with content database limit SharePoint 2013.

SharePoint Hierarchy: SharePoint 2016 Content Database Limits

We’ll also discuss the SharePoint 2016 Content Database Limits by exploring the following:

You might also like to read SharePoint 2019 Limitations.


SharePoint 2016 Content Database Limits

In this section, we’ll explore the below SharePoint 2016 Content Database Limits:

  • Content databases per farm.
  • Content databases per web application.
  • Content database size (General Usage).
  • Content database Size (All Usage).
  • Site collection per content database.
  • Content database items.
SharePoint 2016 Content Database Limits

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


How many content databases per farm in SharePoint 2016?

The number of content databases per farm in SharePoint 2016 is 500 content databases.

How many content databases per web application in SharePoint 2016?

The number of content databases per web application in SharePoint 2016 is not specified. however, the web application can hold the max number of content databases per farm that is 500 content databases.

Note: the supported number of web applications per farm is 20 web applications, so if you are planning to create 20 web applications you can consider the supported content databases per web application is 25 content databases. (500 content database /20 web application) = 25.

What’s content database size in SharePoint 2016?

  • In general usage, the content database size in 200 GB up to 1 TB.
  • In all usage, the content database size is 4 TB.

How many site collections per content database in SharePoint 2016?

The number of site collections per content database in SharePoint 2016 is 10,000 site collections.

It’s strongly recommended 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.

How many content database items per content database in SharePoint 2016?

The number of content database items per content database in SharePoint 2016 is 60 million items including documents and list items.

You might also like to read SQL Server Best Practices for SharePoint 2019


SharePoint Content Database Limits Summary

The following table lists the recommended guidelines for SharePoint 2016 Content database limits compared to

  • Content database limit SharePoint 2013,
  • Content database limit SharePoint 2010,
  • Content database limit SharePoint 2007.

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

LimitsSharePoint 2007SharePoint 2010SharePoint 2013SharePoint 2016
Content databases per farm

x

x

500 per farm500 per farm
Content databases per web application100 per web application300 per web application

x

x

Content database Size (General Usage)100 GB200 GB200 GB200 GB up to 1 TB
Content database Size (All Usage)> 100 GB4 TB4 TB4 TB
Site collection per content database50,000 per content database2,000 recommended

 5,000 maximum

10,000 maximum (2,500 non-Personal site collections and 7,500 Personal Sites, or 10,000 Personal Sites alone)5,000 recommended
10,000 maximum
Content database items

x

60 million items including documents and list items60 million items including documents and list items60 million items including documents and list items
Remote BLOB Storagex< 20 millisecondRemain within 40 milliseconds 95% of the time.Remain within 40 milliseconds 95% of the time.
SharePoint 2016 Content Database Limits

Conclusion

In conclusion, we have explored SharePoint 2016 Content Database limits compared to content database limit in SharePoint 2013, 2010.

Applies To

  • SharePoint 2016.
  • SharePoint 2013.
  • SharePoint 2010.
  • SharePoint 2007.
Download

Download PowerShell Script: SharePoint Farm Scan Report to get statistics and monitor the limits in your SharePoint farm.

You might also like to read
References
Have a Question?

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

6 thoughts on “SharePoint 2016 Content Database Limits”

  1. Pingback: SharePoint 2019 Limitations | SPGeeks

  2. Pingback: SharePoint 2010 Limitations | SPGeeks

Leave a Reply