Speed up FIM 2010 R2 SQL performance by rebuild/reorganize indexes


Recently a user in the Technet Forum had performance issues with SQL MA’s on Syncs, see this Thread. This can happen over time mostly in large environments or environments many changes.

The problem was fragmentation of indexes, and the solution was to rebuild/reorganize these indexes as documented in the Deployment Guide for FIM.

I followed the best practices in mostly all of my projects, also for the SQL Server deployment, but don’t have in mind to check the indexes regularly or on performance issues. So keep that in mind (as I do now) that maybe the Reorganize or Rebuild of SQL indexes can solve your problem.

Advertisements

About Peter Stapf
Senior Consultant Identity and Access MVP (Enterprise Mobility)

One Response to Speed up FIM 2010 R2 SQL performance by rebuild/reorganize indexes

  1. Pingback: Maintenance of Indexes and Fulltext-Catalog of FIM SQL databases | JustIDM

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s