General discussion

  • Creator
    Topic
  • #2176825

    MS-Project 2003 Professional Performance

    Locked

    by pmqueen ·

    We have a project schedule that is approaching 20,000 tasks. It takes several minutes to load or calculate. This is the case for ethernet or token ring connection. The PC surpasses Microsoft’s minimum requirements. Any thoughts on what the problem could be?

All Comments

  • Author
    Replies
    • #3331718

      Reply To: MS-Project 2003 Professional Performance

      by bfilmfan ·

      In reply to MS-Project 2003 Professional Performance

      What speed is the network connection?

      Is the network connection fully duplexed?

      What is the size of the file we are discussing?

      What other traffic is on this segment?

      Is the file located on a workstation or a server?

      What operating system is this system using?

      What does performance monitor show happening on that system during the opening of this file?

      This could be so many different issues that we need more information to relate a reasonable fix.

    • #3331583

      Reply To: MS-Project 2003 Professional Performance

      by pmqueen ·

      In reply to MS-Project 2003 Professional Performance

      We have eliminated all connection and network areas as the problem. The only variable is the version of MS-Project. The file was created in MS-Project 2000. When you open it in MS-Project 2003, the performance issue occurs. The file is 9.57 MB. I talked with Microsoft yesterday. He mentioned something about needing to bring over this file via a wizard. I’m not sure what he is talking about. I have another contact to call today.

    • #3350729

      Reply To: MS-Project 2003 Professional Performance

      by exclubiz ·

      In reply to MS-Project 2003 Professional Performance

      1) Are you running the MS Project as a standalone application? or you are connected with a Project Server?

      2) Is the mpp file is shared by multiple people?

      • #3350693

        Reply To: MS-Project 2003 Professional Performance

        by pmqueen ·

        In reply to Reply To: MS-Project 2003 Professional Performance

        I accidentally answered my own question! Here is the response to answer 2’s questions.

        1) Are you running the MS Project as a standalone application? or you are connected with a Project Server? We have tried it both ways. When running standalone, there is no performance issue. Microsoft was on-site recently and saw the issue in action. It appears to be something quirky in the connection to the web project server. Could it be a network setting mismatch? I’m not a network guru so I don’t know what the problem is. They are trying to nail it down.

        2) Is the mpp file is shared by multiple people? No. Only 1 project manager is working with the file. There are no resources assigned, no dependencies, and no work. Just the task names.

    • #3350698

      Reply To: MS-Project 2003 Professional Performance

      by pmqueen ·

      In reply to MS-Project 2003 Professional Performance

      Response to answer 2:

      1) Are you running the MS Project as a standalone application? or you are connected with a Project Server? We have tried it both ways. When running standalone, there is no performance issue. Microsoft was on-site recently and saw the issue in action. It appears to be something quirky in the connection to the web project server. Could it be a network setting mismatch? I’m not a network guru so I don’t know what the problem is. They are trying to nail it down.

      2) Is the mpp file is shared by multiple people? No. Only 1 project manager is working with the file. There are no resources assigned, no dependencies, and no work. Just the task names.

    • #3340855

      Reply To: MS-Project 2003 Professional Performance

      by exclubiz ·

      In reply to MS-Project 2003 Professional Performance

      One more point to be noted is that which Operating System are you currently using.

      1) If it is Windows XP, then install the Service Pack 2 as soon as possible.Most of office applications are bit slow in Windows XP and since your file size is also large, then it is always better to have the latest service pack.

      2) If it is possible use project server, then you can convert/publish these tasks into the server, so that the data will be stored in SQL server database.

      • #3340839

        Reply To: MS-Project 2003 Professional Performance

        by pmqueen ·

        In reply to Reply To: MS-Project 2003 Professional Performance

        Running Windows XP SP2. Runs fine on the workstation. It’s when you are connected to the project web server that the performance issue occurs.

    • #3244906

      Reply To: MS-Project 2003 Professional Performance

      by furqan asrar ·

      In reply to MS-Project 2003 Professional Performance

      We have a similar problem only that there are lesser tasks but dependencies, baseline etc.

      You could try Shrinking the database on the SQL Server. That solved some of the problem I had before.

      If you read the (I think) Top 10 recommendations you will find a setting to enhance the SQL Server performance by increasing the packet size. Although I have not done it on my production server, my test server has not been affected too much. Its a recommendation nonetheless…

    • #3236947

      Reply To: MS-Project 2003 Professional Performance

      by pmqueen ·

      In reply to MS-Project 2003 Professional Performance

      This question was closed by the author

Viewing 6 reply threads