Recently worked an issue where we were experiencing an extremely slow Full Synchronization. The Full Synchronization was so slow, that it appeared as if it was hanging and not processing. In our troubleshooting, we executed the following actions:
Review of Statistics
Here we noticed that the FIM Service Management Agent contained 200,000+ Pending Exports.
The first problem here is the TempDB auto grow being at 1 MB. The auto grow being so small, can provide issues with a slow synchronization.
The next problem here, is that having over 200,000 Pending Exports triggers the by design Object Whacking issue. This is where a Pending Export is deleted and re-added. Object Whacking must touch any object mentioned in a reference attribute on objects
that are being deleted and re-added.
Additionally, our SQL Server Support Team was able to identify the contributor to the high number of Lock:Timeouts to be the GhostCleanUpTask Process.
1. Set the Auto Grow for the TempDB to be between 300 MB and 500 MB
Clear the Pending Exports
Full Synchronization on Active Directory Management Agent
FIM Landing Page: Resource Wiki and Troubleshooter Wiki Index Page