How to limit the number of sites in a content database?

In real world implementations, we need to configure the Max Site property of content database.


This property is important that:

  1. It prevents further site creation
  2. It prevents unmanageable growth

How to perform?

Open Central Administration > Content Databases


In the appearing window click on your database.


You will get the following page.


Scroll down to see the following properties.  You can change the warning limit & maximum number.


By default the Max Limit is 5000.


The recommended content database size is 200 GB in normal scenarios.

With high IOPS systems the recommended database size is 4 TB

SharePoint Administrator/Architect need to foresee the future growth requirement & come up with the maximum site limit.

Leave a Reply

Your email address will not be published. Required fields are marked *