Performance

[Andrea Padovano]

What about performance in a Project 2003 enviroment ? I noticed poor
performance on a 2003 enviroment on SQL server, compared to the same
solution on file server.

Any feedback about ?

Saving and opening is slow and master file are not so quick.

Thank you.

 

[Nikolay]

We found some performance issue using PWA against PS2003 for big projects
and resource lists. See details and solution in "Performance issue for
Project Server 2003 thread" in this newsgroup.
Nick

 

[Andrea Padovano]

I' ve read that on an other site.

My problem is opening and saving projects, both via ODBC and Project Server.

In other installation we have no significant performance issues (Project
2002 or File Server).

Could be an index (sql server) related problem ?

Anyone experimented performance issue opening and saving projects (i mean 1
to 10 factor) ?

Thank you.

_____________
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.

......

Nick
_______________

 

[Nikolay]

I don't know about SQL server. We have it installed on separate box.

What do you mean about 1 to10 factor?

Did you try suggested registry setting?

Nick

 

[Andrea Padovano]

Could you repost the article please. In that I read there was not registry
setting suggested.

Thank you.

 

[Nikolay]

Andrea,

Try this suggestion. It is works fine for our issue.

A new registery key needs to be created in the Window 2003 Server:

HKLM\SYSTEM\CurrentControlSet\Services\HTTP\Parameters\EnableCopySend of
type of DWORD, value set to "1"

After rebooting server computer check performance again. You should get
sufficient improving performance using PWA for big projects and resource
lists on remote clients.

Let me know, please, if its suggestion works for you also.

Nick

 

[David Harmor]

You may want to examine the indexes for the MS Projects tables on the
SQL Server. I found that the table indexes for MS Projects were not at
all optimal, and the Index Analysis for MS SQL (When it worked) made
things worse. So I studied the MS Project schema and created the
indexes manually. Opening and saving a MS Projects consolidated file
(83 inserted files, each with about 30-50 tasks) went from 7 mins down
to 1 min 14 secs.

We are on a older set-up, MS Projects 2000, MS SQL 7.0, Win NT 4.0
Server with a smoking dual PII-450 Mhz.

 

[Boris Tyukin]

David,

could you please share with us what kind of indexes and for which tables you
applied to

Thanks in advance