- JADOTA – Just Another Day Of The Admin! - http://www.jadota.com -

SharePoint 2010: A huge Admin Content DB

Three weeks back we noticed that the disks on our Microsoft SQL server were filling up rapidly. Further investigation showed that the SharePoint 2010 Admin Content database had exploded from a comfortable 3GB to a whopping 173GB. This could not be right!!!

We ran a report on the Admin Content DB on the SQL server to show us the Disk Usage by Top Tables. This report showed us that the following two tables had an enormous size with many millions of records:



After some digging around in the EventCache table of the Admin Content DB we found that there were an outrages number of entries referring to the /site/Help site on our Central Admin site. It was the article of¬† Veena Sarda (Sharepoint 2010 Internals – Series 2 [1]) that gave us a a hunch that one of the indexes on the help site’s lists had exploded. It would eventually be a index on a column in the Help document list.

Here is what we did to resolve this rather nasty problem:

When the deletion task has completed, check the Disk Usage by Top Tables report on the Admin Content database again to see if they have shrunk in size. If so, please shrink the database using the the SQL Server Management Studio (Shrink a Database [2]). Again this can take many hours, depending on the damage.

After a good, long wait your problem with the exploded database should be resolved. I don’t know if this is a lasting solution, but a few days later the database has not grown much.

Be sure to recreate the index on the Locale ID column again.

Repeat the same steps for any of the other indexed columns on the help site, if the problem is not completely solved.

To know more about database management, start going here [3] to see additional data development information.

Incoming search terms: