Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand
  • Advertisements

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

Posted by Paul on February 25, 2014

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

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s