SharePoint 2010: A huge Admin Content DB

Filed Under (SharePoint 2010, SQL Server 2008) by Just An Admin on 01-11-2013

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:

 

dbo.NameValuePair_Latin1_General_CI_AS

dbo.EventCache

 

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) 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:

  • Go to your CA site’s help site, example http://adminurl:2010/sites/Help
  • Select Site Actions
  • Select View All Site Content
  • Select the document library Product Help
  • Select the Library option in the top bar
  • Select the option Library Settings
  • Select Indexed Columns under Columns
  • Select the Local ID index
  • Select Delete. This action can take many hours, depending on how badly the index exploded. It took me over 18 hours on a RAID-10 storage.

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). 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.

Incoming search terms:

Post a comment