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.
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')
Set the Auto Grow for the TempDB to be between 300 MB and 500 MB
Clear the Pending Exports
Export on FIM Service Management Agent
Delta Import (Stage Only) and Delta Synchronization to confirm Export
Full Synchronization on Active Directory Management Agent