G
GAR
On our EPM system MSP 2003 sp2a (1 front end, 1 database, not using
sharepoint, 250 users, 30 pjms) we are experiencing inconsistent
performance on our timesheet update cycles.
We've had cases where it's taken a local project manager 4 hours to
get through (15 projects) with more than 20 resources. However, the
slow performance is not consistent, a typical speed for this would be
15-20 minutes. The network latency between the database and thick
client is low (less than a millisecond). We haven't been able to
isolate the issue, but feel it could be linked to internal network
traffic / environment , low performing client computers and concurrent
updates happening at the same time.
We've been asked to almost double the number of users accessing the
system and are concerned that our current environment will be
adversely affected. Is our concern valid?
We've been thinking of a couple of infrastructure improvements.
Firstly increase the RAM on the Project Server from 2GB to 4GB. The
other is to add an additional front end in a load-balanced
configuration. I don't think either of these improvements will have
much impact on the issue above as the resource heavy functions of open/
close and the timesheet update cycle rely more heavily on Professional
which connects directly to the database. Is my understanding correct?
Any advice on how to further trouble shoot this type of problem? Has
anyone ever encountered or heard of this issue? I've seen a couple
posts that are similar but no definitive answers.
Thanks,
sharepoint, 250 users, 30 pjms) we are experiencing inconsistent
performance on our timesheet update cycles.
We've had cases where it's taken a local project manager 4 hours to
get through (15 projects) with more than 20 resources. However, the
slow performance is not consistent, a typical speed for this would be
15-20 minutes. The network latency between the database and thick
client is low (less than a millisecond). We haven't been able to
isolate the issue, but feel it could be linked to internal network
traffic / environment , low performing client computers and concurrent
updates happening at the same time.
We've been asked to almost double the number of users accessing the
system and are concerned that our current environment will be
adversely affected. Is our concern valid?
We've been thinking of a couple of infrastructure improvements.
Firstly increase the RAM on the Project Server from 2GB to 4GB. The
other is to add an additional front end in a load-balanced
configuration. I don't think either of these improvements will have
much impact on the issue above as the resource heavy functions of open/
close and the timesheet update cycle rely more heavily on Professional
which connects directly to the database. Is my understanding correct?
Any advice on how to further trouble shoot this type of problem? Has
anyone ever encountered or heard of this issue? I've seen a couple
posts that are similar but no definitive answers.
Thanks,