none
Excessive delays and queue problems with Project Site sync RRS feed

  • Question

  • A customer is having huge delays and problems caused by the Project Site sync jobs in the Project Server queue. They were running an AD sync twice weekly for several months without issue - it always completed overnight. Then they increased the frequency to every night - starting about 10pm. This was okay for about two weeks, before suddenly on the Tuesday of last week, they noticed that a lot of the sync queue jobs from the night before were still sitting waiting on the queue in the morning - almost 2,000. The AD group sync part works without flaw, however it is when Project Server goes through and updates the groups on all the project sites that seems to be taking the longest amount of time. All other queue entries are processed at normal speed. Originally it used to be able to do a few several hundred of these sync jobs per hour overnight - but now it has degraded to about 20-30 entries per hour regardless of the time of day/night.

    What could possibly cause such a sudden increase in processing time? Why does the project site sync seem to remove and re-add every single user that has permission to every single site?

    Regards,

    Ashley

    Wednesday, July 24, 2013 2:23 PM

All replies

  • Ashley,

    Adding/Removing every single user is by design behavior. Prior to 2010, server used to remove all the users  and then add it back to refresh the security update made by admin like  updating groups and categories, which has caused lot of issue for WSS root site sync job failure especially  with large pool of users. In such scenario is job is failed all the users used to get access denied error. MS has changed this behavior in 2010 by dealing with one user at a time, only post failure job user would get effected.

    About the delay in processing , make sure that you have MS recommended database maintenance plan is in place. Server time on all the servers in the farm should be exactly the same. Delay of few seconds could also impact queue job processing.

    What is the purpose of running this job daily? 


    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you.This can be beneficial to other community members reading the thread.

    Wednesday, July 24, 2013 4:32 PM
    Moderator
  • HI

    You can re-index the databases to improve the performance. The script can be reviewed here in  the below site

    http://msdn.microsoft.com/en-us/library/ms188917.aspx

    Also you can follow the below article to improve the queue performance

    http://blogs.msdn.com/b/brismith/archive/2012/09/19/when-your-project-server-queue-slows-down.aspx

    Monday, August 5, 2013 2:15 PM