none
2013 Microsoft.Office.Project.Server.Calculation - server side calculation engine is slowing client responsiveness RRS feed

  • Question

  • This process is utilizing a a single core at 90%, is there a way to boost the performance of this process? Meaning can it become multithreaded, can the priority be set does a certain processor help. Should hyperthreading be disabled but that would be hard on a VM.  This is just one guy beginning a rollout playing publisher and updating users. I figure I must be doing something wrong because even a small rollout would lock this for days.



    • Edited by Toomanyhats Tuesday, February 5, 2013 7:02 PM
    Tuesday, February 5, 2013 6:59 PM

All replies

  • If the process is running 90% then it cannot be boasted any more.  Can you give it more processes?  Can you give this VM more processes to work with.   Perhaps more memory would lower the CPU utilization.  How much memory is being allocated.   Or it may be page faulting, which causes high processing.

    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

    Wednesday, February 6, 2013 1:25 AM
    Moderator
  • How do I give it more processes? Thread count is often over 100. There are 3 cpu cores siting idle, how do I establish an afinity for more? The memory is unlimited the server runs around 10 Gig start up at 16gig but the VM can have as much as it wants based on demand. I see no memory hard faults in the task manager.
    Wednesday, February 6, 2013 2:51 PM
  • If this is a VM, then shut down the VM and configure it for more processes.

    If this is a VM, then shut down the VM and give it more memory on reboot

    How much physical memory does the system have?

    WHat version of Windows are you running?


    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

    Wednesday, February 6, 2013 2:57 PM
    Moderator
  • 64 gig host memory, windows 2012 host and guest, VM has starting memory 16gig dynamic to 32gig, VM has 4 virtual processors. I don't now how to set more processes, just processors. I mentioned in the first post that the 90% on this scheduling engine is on a single core within the VM while 3 others are sitting idle. This is why I think I've done something wrong. If a single publish action can lock this process for 8 minutes, how can this platform scale?
     Thanks
    • Edited by Toomanyhats Wednesday, February 6, 2013 4:19 PM
    Wednesday, February 6, 2013 4:19 PM
  • With the specs you're quoting, running on hyper V 2012, the system should be screaming fast, so it sounds like a your suspicion of a bad configuration is entirely possible. With that said, this is hardly the place to troubleshoot system level problems.

    Gary Chefetz, MCITP, MCP, MVP msProjectExperts
    Project and Project ServerFAQs
    Project Server Help BLOG

    Thursday, February 7, 2013 9:35 PM
    Moderator
  • I agree with Gary's point.  You have plenty of horse power.  The issue is something like your virus protection not being setup correctly, or hardware issue generating events.

    The point is that something is not setup properly.  Typically the processing is close to zero when system is not working.  You may see a blip in the processor when a project is saved or published.  Very easy to do with so many system items to coordinate.

    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

    Friday, February 8, 2013 5:11 AM
    Moderator
  • this is hardly the place to troubleshoot system level problems.

    where do you suggest?

    Friday, February 8, 2013 4:19 PM
  • If you have several months to go back and forth in the forum.  This may work for you.  If you have a deadline then you may want to contact a project server consultant and have an someone review your installation. 

    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

    Friday, February 8, 2013 4:24 PM
    Moderator
  • I was quoting Gary and then asking where I should have posed the question?

    Since to me this seems like the best forum to get information about the usual behviour of the Microsoft.Office.Project.Server.Calculation Process.

    Friday, February 8, 2013 6:00 PM
  • My bad. The forums are a good place to start. It's just so many factors that can cause performance issues.  It looks like you have plenty of performance.  When the CPU goes to 90%, how much time are you taking about roughly. 

    Are you talking seconds, minutes, hours or days?  A spike of 90% isn't so bad.

    It almost sounds like Excel is using other threads when executing.  I often see spikes in one thread when monitoring a server.


    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

    Friday, February 8, 2013 6:39 PM
    Moderator
  • The spike is when a publishing action takes place. 5->10 minutes on a project with a thousand tasks.

    This project is then locked for that duration.

    I also saw a spike for a couple times when changing the project owner.

    A new project with say 50 tasks, is 2 minutes or so on a publish operation.

    Now the real problem I'm having is imagining how this could happen. The offending operation is the Microsoft.Office.Project.Server.Calculation Process(90%) but I made these observations with a single user. What it 6 people publish at the same time (since it appears this Microsoft.Office.Project.Server.Calculation Process is single threaded). Well then you could maybe get 4 cores running Microsoft.Office.Project.Server.Calculation Process(90%) but that would still lock the server for some time. I just can't believe this design is proper when the rest of the farm is sitting idle.

    Friday, February 8, 2013 8:21 PM
  • Could be in your project schedule.  There are some things to try to avoid.  Do you have task with over 8 resources assigned to it?  What is the largest number of resources that you have assigned to one task?

    What is the longest duration that you have for a task?

    Other than project having over 1000 tasks, can you provide other details that you may be suscious of.

    How many resources does the project have?

    Are you using an assortment of calendars or you just using the out-of-box Standard calendar.

    Do you have any resources that have %unit as less than 1%.

    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

    Friday, February 8, 2013 11:35 PM
    Moderator
  • 25 resources,

    only one resource per task,

    10 calendars,

    fully levelled,

    no % units.

    I found a reference to an SQL problem. Apparently the early SQL 2012 ISO that included SP1 was broken. I repaired that so will test again.

    Monday, February 11, 2013 2:26 PM
  • still slow
    Tuesday, February 12, 2013 12:48 PM
  • Do you have virus protecton on either SQL or SharePoint Server?

    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 12, 2013 2:24 PM
    Moderator
  • No, firewall is off.

    I am no longer getting any kind of effort on any process on any server. Nothing over 10% anywhere, no memory ceiling, only thing that seems active during a publishing action is the SQL server tempbd (Queue depth is never over .5) and there is also about a 1.5 Mb/s network traffic between the two servers. The Microsoft.Office.Project.Server.Calculation Process no longer registers anything more than a blip of CPU time. The highest one is the Queing Service, under 10% usually 4%.


    • Edited by Toomanyhats Tuesday, February 12, 2013 3:41 PM
    Tuesday, February 12, 2013 3:40 PM
  • I am not talking about the firewall.  Do you have VIRUS PROTECTION enabled on either the SQL Server or SHAREPOINT server.  When virus protection is on, all the files and temp files are inspected by the virus protection software.  This kills performance.

    So have you check to see if VIRUS PROTECTION is enabled.  If so, which version.


    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 12, 2013 6:00 PM
    Moderator
  • Ooops..

    I meant,

    No antivirus, also no firewall.

    Unless Security Essentials (or similar) for Server 2012 is somehow enabled and I can't find it.

    Tuesday, February 12, 2013 7:31 PM
  • I tore down the old Project Server Instance and rebuilt a new one.

    This one is all on one server. Initial performance tests are good but there are a lot more features yet to add...

    most concerned about

    FBA aspnetdb Membership provider

    and MySite.


    • Edited by Toomanyhats Thursday, February 28, 2013 7:24 PM
    Thursday, February 28, 2013 4:29 PM
  • What I meant by my statement is it's not efficient or very satisfying to troubleshoot complex issues in a TechNet forum. There are so many steps to a good clean Project Server installation, many of which are not currently well documented by Microsoft, that is is very difficult to help someone diagnose a missed step when you cannot share a roadmap. That's what Bill Raymond and I have been working on and the reason for my late reply.

    The ten calendars you mention later in this thread are a potential performance problem. If a project with thousands of tasks uses ten calendars, that (unusual) condition can generate an enormous amount of data in some cases, and it creates much more work for the calculation engine. Unusual assignment data requirements may also require unusual or extraordinary SQL configuration steps, system configuration steps, and network tuning to accommodate the load.

    When I run into unusual project complexity, I always look for ways to simplify the data first, but sometimes it is what it is.


    Gary Chefetz, MCITP, MCP, MVP msProjectExperts
    Project and Project ServerFAQs
    Project Server Help BLOG

    Friday, March 1, 2013 12:31 PM
    Moderator
  • New server (all in one with SQL) is running well,

    Not fully configured yet but the FBA, MySite, Enterprise Search are running and 1200 line Projects with 25 custom resource calendars publish in under a minutes with every task rescheduled.

    Over the next couple days I will be able publish multiple projects with inclusion of multiple lookuptable(600item) custom fields columns and get the OLAP cube running. That will be a more realistic configuration test.


    Tuesday, March 5, 2013 9:10 PM
  • As I advanced up the configuration and customizing I ran into a problem when creating a Project level custom field, based on a simple text lookup table.  Once this Custom Field was Assigned to the Project Details this is when the Microsoft.Office.Project.Server.Calculation spiked and the save publish became stupid.

    Update

    Well I deleted the custom field (project type) retained original look up table, republished then readded a new equivalent custom field and publishing worked quickly again. Two other things changed that I'm not sure if they are related. One OLAP cube was disabled and I re enabled it, also I included a value for the standard Project Department non custom field.

    • Edited by Toomanyhats Thursday, March 7, 2013 9:36 PM
    Thursday, March 7, 2013 3:19 PM