Share via

FIM: How to reindex all of the tables in the backend FIMSynchronizationService Database

  • Article

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
    • 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
    • *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