After the upgrade of our 7.0.3 service to version 7.1.2 the sync service is extremely slow now. The part that is slow is when the sync service performs the step in every workflow called 'Processed objects: Target Active Roles Server'. This portion used to only take minutes and now takes hours. It seems to only be processing about 1000 ARS objects at a time.
I have heard that maybe indexing a portion of the sql table might help, does anyone have any helpful direction to point me in?