Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Abnormal Growth in the the Share Point Content Database

  Asked By: Isaiah    Date: Apr 25    Category: Sharepoint    Views: 1846

I am facing a strange a issue in Share Point Application .
The content in the Share Point application is only 5 GB data but the Content
Database is showing nearly 100 GB.
and that to Content Database is growing abnormally.
we Mentioned that the auto growth as 10gb.



11 Answers Found

Answer #1    Answered By: Jesica Battle     Answered On: Apr 25

Do you have versioning turned on in any of the document libraries? If so,
each version of a document (both major and minor) is a full copy of the
file. This can add up very quickly.

Answer #2    Answered By: Mari Boyle     Answered On: Apr 25

yes we enabled the Versioning for most of the document libraries in the

So you want me to disable the versioning option in my Site collection for
the documentlibraries right ?

Answer #3    Answered By: Kaci Peck     Answered On: Apr 25

How to check whether which document library is using more memory size ?why
because more than 100 document libraries and 80 list are there in the site

Is there any third party tool is available to check for this ?

we are not using any quota templates in the site collection.

Answer #4    Answered By: Roberto Holmes     Answered On: Apr 25

Without quotas your recycle bin will have no growth limit. Depending on how
your recycle bin is configured you may never recover space from 'deleted'
items. From Central Admin you can check this at Application Management ->
Web Application General Settings bottom of the page.

Once you enable a quota on the site collection you can check the usage of
your doc libraries and lists in a site collection via: Site Actions -> Site
Settings -> Storage Space Allocation

Answer #5    Answered By: Candis Kinney     Answered On: Apr 25

If you require versioning then you also should enable quota's.

Do you have Major and Minor versioning enabled?

Answer #6    Answered By: Christie Carlson     Answered On: Apr 25

In talking with my server admin it was a SQL script not an STSADM command. Run
it against your main content  database:

SELECT ItemChildCount + FolderChildCount
as Items, DirName +'/' + LeafName as RelativePath
WHERE ItemChildCount + FolderChildCount > 1700

Answer #7    Answered By: Utsav Shah     Answered On: Apr 25

We recently saw this sort of issue  with a shared calendar on our tech support
site. Everyone had connected to it and then, for some reason, whenever someone
would put an entry on to it the entry would double, and then quadruple, and
then... you get the point.

I don't remember what the tool was that they used (it is built into SharePoint,
NOT third-party) but it showed them which list it was and they were able to just
delete that list.

I also don't remember what the original issue was that allowed it to go haywire.

Answer #8    Answered By: Breann Beach     Answered On: Apr 25

Are quotas enabled? Also what are the recycle bin settings for the web ap?

Answer #9    Answered By: Lyndsay Montoya     Answered On: Apr 25

Please check your database  log file and try to shrink it or delete and
truncate the log and create a new one.

Answer #10    Answered By: Darien Good     Answered On: Apr 25

Maybe this was already suggested, but have you:

1. Deleted sites/site collections and not reduced the white space in SQL?

2. Trimmed the audit logs lately?

3. Tried shrinking the DB from SQL?

4. 10GB is a big autogrow, you might change it to 1GB and then do a DB

Didn't find what you were looking for? Find more on Abnormal Growth in the the Share Point Content Database Or get search suggestion and latest updates.