SharePoint 2016 content database size increase

Database increasement happens, when you insert additional data.

Stopp adding data and database increasing stops (... sorry for that joke:-)

secondary datastore such as .ndf system

The database file group/files structure is for client as SharePoint completely intransparent, they aren't aware of. So yes, you can add additional database files.

Hi @Jian Hong Lek ,

SharePoint 2016 supports increasing the size of a content database up to 4 TB, provided that certain requirements are met, such as disk subsystem performance and high availability plans. However, it is strongly recommended to limit the size of content databases to 200 GB, except when specific usage scenarios and conditions support larger sizes. In this case, the customer's SharePoint site is already at 700 GB, which is well beyond the recommended limit.

To address this, it is recommended to split the content database into multiple databases, rather than increasing the size of the existing database. This can be done by moving site collections to different databases. It is suggested that for ease of backup and restore, individual site collections within a content database be limited to 100 GB.

It is also recommended to proactively manage the growth of data and log files by pre-growing all data and log files to their expected final size, enabling autogrowth, and setting the database autogrowth value to a fixed number of megabytes instead of a percentage.

For your references:

• Storage and SQL Server capacity planning and configuration (SharePoint Server)
• Software boundaries and limits for SharePoint Servers 2016 and 2019

Hope this is helpful.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.