1. PSSDIAG (SQL Server Diagnostics Tool)
a. This displayed that we were processing records, but at an extremely slow rate. PSSDIAG did indicate that there may be a problem with the growth of the TempDB. In investigation, we found multiple TempDBs for the multi-core processor. The first TempDB looked ok, but the other TempDBs had a 1 MB auto growth.
2. Review of Statistics
a. In the Synchronization Service Engine, we reviewed the Statistics Dialog. ( Tools > Statistics )
b. Here we noticed that the FIM Service Management Agent contained 200,000+ Pending Exports.
Additionally, our SQL Server Support Team was able to identify the contributor to the high number of Lock:Timeouts to be the GhostCleanUpTask Process.
SELECT object_name(object_id) as Name, record_count, GHOST_RECORD_COUNT,Version_ghost_record_count,INDEX_TYPE_DESC, ALLOC_UNIT_TYPE_DESC FROM sys.dm_db_index_physical_stats (DB_ID(N'FIMSynchronizationService'), object_id('mms_connectorspace'), NULL, NULL , 'DETAILED')
RESOLUTION
1. Set the Auto Grow for the TempDB to be between 300 MB and 500 MB
2. Clear the Pending Exports
a. Export on FIM Service Management Agent
b. Delta Import (Stage Only) and Delta Synchronization to confirm Export
3. Full Synchronization on Active Directory Management Agent