Update Speeds

[dietmarhannam]

Here's my scenario:

1. I have a user who raises an Issue
2. The Project Manager (PM) sees the issue and raises a task to resolve
the issue.
3. The PM publishes the changes
4. The PM goes to the relevant Issue and tries to link it to the task.

The problem i'm having is task takes up to 5 minutes to appear on the
list so i can link it to the Issue.

Is there any way of speeding this process up? All e-mails are sent
immediately and the task is added to the Project Web Access view
immediately.

Thanks,

Dietmar

 

[Paul Conroy Designtech]

It's difficult to say exactly where this bottle neck is but the areas to look
at are:-

If your operating with many large projects (1000+) tasks, then consider
separating the views processing service from the front end service, as it is
the views processing service that updates the database from the published
files in the viewdrop folder. You can create a NLB cluster for the views
processing service so that more than one server handles these updates.
Separating the VP service from an existing installation requires a complete
reinstallation of project server.

Run the project server health monitor, this may help point out where the
bottle neck is.

Is the SQL server overloaded/busy. can you place the PS database onto a
different drive. If the database is getting very large, you can partition it
up to improve performance. The project server resource kit explains how to
do this.

 

[dietmarhannam]

Ok, thanks for your help.

I will try running the project server health monitor and see what
happens, this seems my preferred option at the moment.

Thanks again,

Dietmar