PURPOSE / GOAL

We often times recommend re-indexing the backend tables in the FIMSynchronizationService Database.  The goal of this article is to provide the steps on how to re-index all of the tables in the backend FIMSynchronizationService Database.

STEPS TO RE-INDEX

  1. Stop the FIM Synchronization Service via Services MMC
    1. Click Start > Run and type services and then click Enter Or Navigate to Administrative Tools, and select Services
  2. On the SQL Server, open SQL Server Management Studio
  3. Connect to the SQL Server hosting the FIMSynchronizationService database
    1. *NOTE: If you are using a previous identity product, then the database name will be MicrosoftIdentityIntegrationServer.
  4. Click the New Query button
  5. In the white space paste the text from the script section
  6. Once you paste the script, then click the Execute button
  7. Start the FIM Synchronization Service via Services MMC

SCRIPT

USE FIMSynchronizationService (*NOTE: If you are using a previous identity product, then the database name will be MicrosoftIdentityIntegrationServer.)

 

 

DECLARE @table_name varchar(1000)

declare c1 cursor for SELECT name

      FROM sysobjects

      WHERE xtype = 'U'

open c1

fetch next from c1 into @table_name

while @@Fetch_Status = 0

begin

      DBCC DBREINDEX (@table_name, '')

      fetch next from c1 into @table_name

end

close c1

deallocate c1

GO

SEE ALSO
Database Management for the ILM Synchronization backend Database

ADDITIONAL RESOURCE WIKI

è Forefront Identity Manager Wiki
è GalSync Resource Wiki
è PCNS-Password Synchronization Resource Wiki
è Certificate Lifecycle Management Resource Wiki