In real world implementations, we need to configure the Max Site property of content database.
This property is important that:
- It prevents further site creation
- 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.