Paul Liebrand's Weblog

Welcome to my blog mainly about SharePoint

Skip to: Content | Sidebar | Footer

Google Search

User Profile Database Growth Issue Resolved

16 April, 2012 (08:15) | SharePoint | By: Liebrand

It appears the User Profile Database growth issue I posted about previously has been resolved with the February cumulative update for SharePoint 2010.

In my previous post, a temporary solution was provided that involved creating a stored procedure and running it on a scheduled basis to clean up the appropriate tables. In reviewing the KB Article 2597150, it states:

This hotfix package provides store procedures that clean up the Forefront Identity Manager (FIM) history tables during profile synchronization jobs.

If you implemented the workaround, I would encourage you do remove it and then install the February CU.

Here is a link to the February 2012 CU for SharePoint 2010:

http://blogs.technet.com/b/stefan_gossner/archive/2012/03/07/february-2011-cu-for-sharepoint-2010-has-been-released.aspx


Post to Twitter Post to Delicious Post to Digg Post to Facebook Post to Reddit

  • Pingback: Adventures in SharePoint Development - User Profile Sync DB Issues()

  • FatProfile

    Doesnt seem to make profile db smaller at all with april 2012 CU

  • Levente Rog

    Installed April 2012’s CU package and no cleanup jobs in SQL Agent have been created for me. Tried to install the February 2012 package afterwards, but it says that this package is no longer needed.

  • MDC

    I installed the Feb 2012 CU and the db doesn’t seem to make the profile sync db smaller although it now doesn’t appear to grow in size anymore.

  • Zazie

    I applied this patch a few days ago because I was seeing the symptom of the User Profile Service Sync db growing and growing and understood it would include some storied procs to truncate various tables and reduce the overall size.

    Thing is, the db is just as vast as ever. Do you know if there is any further action required to bring the size under control (timer jobs that need running or some such)?

  • Pingback: SharePoint from Scratch » That was nuts!()