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!!!
Incoming search terms:
- – dbo eventcache – NameValuePair_Latin1_General_CI_AS – sharepoint 2010 dbo namevaluepair – sharepoint content db clustered index huge – sharepoint eventcache table size recommendation – SharePoint Foundation 6398 UserProfileImportJob operantion not valid – sp 2010 big db problem – The Execute method of job definition Microsoft Office Server UserProfiles UserProfileImportJob (ID 27de54e6-3086-4fef-b8de-8cf03804678a) threw an exception More information is included below Operation is not valid due to the current state of the object