SharePoint capacity planning plays a very
vital role with respect to any farm, whether it’s a small farm, medium farm or
large farm. Today I am going to share some details and troubleshooting steps
regarding one issue that I faced recently.
Problem
Description: we have received the following
error message while creating the site collection.
Error
Message: The content databases
in this cluster are full. You cannot add more web sites until you change the
content database web site capacity settings or add more content databases.
Troubleshoot issues with Microsoft
SharePoint Foundation.
Troubleshooting
done: From the above error message, 2 points comes
into the picture i.e. database size and number of site collections exist in a
single database.
-Based on analysis, we found out that total
site collections exist are 100 and size of the database was 67GB.
-checked the managed databases section in
central administration with respect to that web application under which we are
trying to create a site collection. We found out that somebody has changed the maximum
site collection limit to 100 and that’s why we were facing that error message.
Resolution:
Please
refer the following steps to get rid of this error message:
-Central
administration
-Application
management
-manage
databases
-select
the appropriate web application from the top
-change the maximum site collection limit to
15000 and warning set to 9000.
That’s it. After this we are able to create
site collections without any issues.
If you have any queries/issues regarding the
above mentioned information then please let me know. I would be more than happy
to help you as well as resolves your issues, Thank you.