Lately I’ve heard a few requests to improve the Project Server queue performance. For instance some of the request I’ve heard are: improve the publishing time from Project Professional, improve the timesheet processing time, etc…
Before going further I highly recommend reading the following article: Microsoft Office Project Server 2007 Queuing System for an in depth understanding on how the queue works.
Assuming the customer has the latest Project Server Service Pack/hotfix, what else can be done to improve performance?
A first option is described in Brian Smith’s blog: Is your Project Server 2007 queue running a few minutes slow?, basically make sure all servers in the farm have the same time.
Another option which requires more work is to identify was is slowing the queue down and act accordingly. For instance start monitoring performance counters (for a list check this: EPM & SharePoint Performance Counters) for each server in your farm and focus on counters when the queue is “slow”, basically try to identify the bottleneck.
Typical bottleneck I’ve seen in the past:
You could also run a SQL Profiler to see what’s happening from a database point of view (check this on how to setup a trace: Running SQL Server Profiler with Project Server).
Another great tool to watch the queue is this from CodePlex: EPM 2007 Queue Watch tool
In the end improving the queue performance could be quick or long to achieve depending on how much you know your farm (performance counters, customization…) and how optimized it is.
Two very useful SharePoint Server articles have been published on TechNet that are directly applicable
After quite a bit of work on this one it appears that SP1 (and a slightly earlier hotfix) were almost