Jean Paul's Blog

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

    Advertisements
  • 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.

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.

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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