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.

image

This property is important that:

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

How to perform?

Open Central Administration > Content Databases

image

In the appearing window click on your database.

image

You will get the following page.

image

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

image

By default the Max Limit is 5000.

image

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 *