Re: Performance issue for Project Server 2003

From: David Gage (dgage_NOSP_at_M_quantumpm.com)
Date: 04/02/04 

Date: Thu, 01 Apr 2004 16:37:33 -0800

Nick wrote:

> Now we are migrating our project management system from MS Project
> Server 2002 on W2k platform to Project server 2003 on Win2003 box.
> Some preliminary experiments with real data shows serious problem
> with performance on PS2003 with using Web Access.
>
> Loading time for big project on client side (about 1000 records)
> against 2003 server approx to 10 times more than on PS2002 (W2k box).
> The same take place for big resource list.
>
> Probably, this strange behavior concerned with ADO RDS recordset
> transmission mechanism from server to client.
>
> We try to capture network traffic via Network Monitor and discovered
> that data exchange take place in following manner:
> each cycle begins from IP client request packet to server,
> immediately after that occur HTTP server reply (some packets
> according max packet size is 1500 byte) and WAITING time until next
> cycle begin. The cycle length is 200 ms EXACTLY.
>
> Analogous monitoring against w2k-PS2002 box shows that WAITING time
> for client requests
> don't present and the same data amount goes to client much more
> rapidly.
>
> Has anybody experienced similar problem?
>
> What can we do for resolving such trouble?
>
> Thanks for any suggestions,
>
> Nick

Nick,

You may want to try installing Project Server 2003 again and maybe to a
different server. My considerable experience with 2003 shows that
performance across the board is much better with 2003. Are you
comparing the exact same projects? Are you connecting to each server
from the exact same desktop?

If you'd like, I would be willing to take a look at your database and
let you know what times we see on our servers. We do Project Server
hosting so I have several I can test against. Consider it a freebie
since I think 2003 is so much better than 2002 and want to help you
come to the same conclusion.

David 

-- 
David Gage
Microsoft Project MVP
QuantumPM

Relevant Pages

  • RE: sendmail blocking
    ... the administrator I don't receive any NDRs. ... >> mail server, and the external world that acts as a mail ... Since Nick has been receiving this junk email for a year now ... marketing mailing lists. ...
    (RedHat)
  • RE: Suspicious joe.exe
    ... I have seen a few programs like this that will allow a user to bounce IRC ... as my postfix mail server will not tolerate .exe files. ... > NICK %s ... > USER %s localhost localhost:%s ...
    (Vuln-Dev)
  • RE: Suspicious joe.exe
    ... I have seen a few programs like this that will allow a user to bounce IRC ... as my postfix mail server will not tolerate .exe files. ... > NICK %s ... > USER %s localhost localhost:%s ...
    (Vuln-Dev)
  • Re: 2003 Server SP1 Issue
    ... Nick wrote: ... >> Addition) to SP1 and it HOSED the system. ... >> I got an error saying that we were not in compliance with licensing ... >> server, it blue screened after 1 minute and rebooted. ...
    (microsoft.public.win2000.general)
  • Re: Performance issue for Project Server 2003
    ... > Nick wrote: ... >> Some preliminary experiments with real data shows serious problem ... >> transmission mechanism from server to client. ...
    (microsoft.public.project.pro_and_server)