none
Queue is too slow while publishing the projects RRS feed

  • Question

  • Hi All

    I want one suggestion from MS Project Server Experts.

    I have an environment, there no. of Project is more than 5k and no of users 400 because of this performance of the queue is too slow. Please suggest some resolution to overcome for the same.

    FYR:

    1. We have 4 Application Server and each server having 32, 14, 32, 20 GB RAM Size (All are in load balancer )
    2. just for test I have deleted most of the project in our Development environment then I  have seen performance is increase but problem is we can't delete Project from Production Server.


    Regards, Pankaj Waghmare - MCTS | Consultant


    • Edited by Pankaj Waghmare Friday, February 14, 2014 3:03 PM To add References
    Friday, February 14, 2014 11:44 AM

All replies

  • Pankaj,

    It seems like you have modeled your farm for a large dataset, so 5000 projects should not be a big deal. 

    My guess is that your bottle neck is on the SQL side. Have you set up maintenance plans for your Project Server Databases? http://technet.microsoft.com/en-us/library/cc973097(v=office.14).aspx

    Also check your queue settings. You might be able to increase the threads with such a horse power on App servers. 

    One final thing, Do you have enough temp dbs?

    Create Additional TempDB Files

    Both Project Server 2010 and Microsoft SharePoint Server 2010 make extensive use of TempDB during SQL transactions. To improve performance, create additional TempDB files. To optimize performance, create an additional TempDB file for each processor (core) in the computer running SQL Server. Create the files on a separate partition from other database files.


    Prasanna Adavi,PMP,MCTS,MCITP,MCT http://thinkepm.blogspot.com

    Friday, February 14, 2014 3:20 PM
    Moderator
  • turn off virus protection if it is enable, to see if performance improves.

    Cheers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Sunday, February 16, 2014 2:17 AM
    Moderator
  • Hi Michael

    Thanks for the reply..

    Yes, I have checked (to turn off the virus protection) but performance is still slow.


    Regards, Pankaj Waghmare - MCTS | Consultant

    Monday, February 17, 2014 6:29 AM
  • Hi Prasanna

    Thanks for the response.. :)

    I have already checked to increase the threads but no there is no impact on performance.

    One more thing, I forgot to mention; we are creating and Publishing project through PSI.


    Regards, Pankaj Waghmare - MCTS | Consultant

    Monday, February 17, 2014 6:32 AM
  • Pankaj,

    Not sure what your response was on the SQL Server Maintenance Plans.. They are really key for your farm performance.

    The only other thing I can think of is to make sure that the clocks are synced on all servers. Even 1 minute difference between servers can cause these kind of issues.

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


    Prasanna Adavi,PMP,MCTS,MCITP,MCT http://thinkepm.blogspot.com

    Tuesday, February 18, 2014 6:55 PM
    Moderator
  • Are you running all your severs on physical boxes?

    If running on Virtual Server, how do you have the VM configured?  Especially the disk drives.  Are they all sharing the same physical disk drive?

    CHeers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Tuesday, February 25, 2014 4:38 AM
    Moderator