none
Project Server 2010 - Project with 13 million lines catching the queue service. RRS feed

  • General discussion

  • Hello Guys. 

    I have a database project in Project Server 2010 with 13 million lines. This design locks the queue service tool. Is there any limitation lines Project to Project Server 2010? If yes, could share the Microsoft documentation where this information is reported. Is there any way to improve this performance? Any feedback is welcome.

    Thanks


    Obrigado por contactar o fórum Microsoft Technet!

    Wednesday, May 14, 2014 1:20 PM

All replies

  • Hi,

    I stopped breathing for a while when I read 13M lines... Obviously it is WAY over the Microsoft recommendations and against all best practices. I'm wondering how such a plan can be tracked, update, read, managed, reported...

    I'd suggest to break it into several project plan. Also I'd advice to do scheduling brainstorming: a project plan is NOT a todo list, a product backlog. Thus if you need to follow low-granularity activities, you can use others tools such as Excel or SharePoint lists.

    That being said, here are some references for you (especially the first link). You'll see that a 10,000+ is already a huge plan that could be 150MB+, talking a long time to save-publish-close-open and obviously stuck the queue.


    Hope this helps,


    Guillaume Rouyre, MBA, MCP, MCTS |

    Wednesday, May 14, 2014 1:32 PM
    Moderator
  • I also add the performance whitepaper link for PS2010 that will give you tips for queue optimization.

    http://technet.microsoft.com/en-gb/library/ff686784.aspx

    See below reference dataset for PS2010 for an instance.

    Entity

    Description/Notes

    Small

    Medium

    Large

    1

    Projects

    100

    5000

    20000

    1

    Tasks

    17125

    856250

    3425000

    1

    Avg. Tasks Per Project

    171.25

    171.25

    171.25

    2

    Task Transaction History

    The number of times status tends to be submitted and approved for any given task

    10

    100

    1000

    1

    Assignments

    22263

    1113125

    4500000

    1

    Avg. Assignments Per Task

    1.3

    1.3

    1.3

    2/3

    Approvals

    Pending updates per manager

    50

    600

    3000

    Users

    1000

    10000

    50000



    Hope this helps,


    Guillaume Rouyre, MBA, MCP, MCTS |

    Wednesday, May 14, 2014 1:34 PM
    Moderator
  • Hi Guillaume, 

    Thanks for information.

    Tasks with number 17125 is the maximum number of tasks per dataset? 
    The experience of users seems that this limit begins to performance issues from 5000 lines.


    Obrigado por contactar o fórum Microsoft Technet!

    Wednesday, May 14, 2014 1:57 PM
  • You're welcome!

    Actually 171,25 is not the maximum tasks per project, since Microsoft is giving dataset for an instance. Let's say that 3,425,000 tasks is a huge dataset for a large instance. Thus 13M is out of boundaries.

    Indeed a 5000 tasks' project starts to be long to save and publish. 10,000+ projects will "loose" your users since they will have to wait for a long time before they can open their projects.


    Hope this helps,


    Guillaume Rouyre, MBA, MCP, MCTS |

    Wednesday, May 14, 2014 2:05 PM
    Moderator
  • Guillaume Rouyre,

    Again thanks for the reply. 
    Could you provide me a way to perform this calculation? How many tasks for dataset? This would be important to calculate the capacity of the instance?

    Thanks.


    Obrigado por contactar o fórum Microsoft Technet!

    Wednesday, May 14, 2014 2:14 PM
  • I'm not a DBA, but from SQL management studio, you should be able to query the reporting database. A "count" on the dbo.MSP_EpmTask_UserView should give you the number of tasks.

    Eventually filter on non-summary tasks with the field "TaskIsSummary" equal to no.


    Hope this helps,


    Guillaume Rouyre, MBA, MCP, MCTS |

    Wednesday, May 14, 2014 2:23 PM
    Moderator
  • I woul recommend SQL Server's Index Rebuild and Update Statistics' Jobs running on a schedule. It's going to take a huge time, but it's worthy.

    http://technet.microsoft.com/en-gb/library/ms180074.aspx

    http://technet.microsoft.com/en-gb/library/ms178678.aspx

    I'm sure you'll reach good results

    Cheers

    Wednesday, May 14, 2014 9:09 PM