In this post we will discuss how we can prevent new sites to be added to content databases that grows more in database size.
Also you can check out:
Suppose the content databases have grown larger than 100 gigabytes (GB). Large content databases can be difficult to back up and restore. And sometimes this causes the application to stop responding when you perform operations that affect entire databases.
Here we can edit the rule definition to prevent new sites from being added to these databases.
We can do this from SharePoint Central Administration.
Open SharePoint Central Administration, On the Monitoring page, in the Health Analyzer section, click Review rule definitions.
Then On the Health Analyzer Rule Definitions page, in the Availability category, click the name of the rule.
In the Health Analyzer Rule Definitions dialog box, click Edit Item, and then select the Repair Automatically check box.
Click Save. You can no longer add new sites to databases that exceed 100 GB.