Welcome to MSDN Blogs Sign in | Join | Help

Brian Smith's Project Support WebLog

What's new and upcoming in the world of Microsoft Office Project Support (PSS).
Is your Project Server 2007 queue running a few minutes slow?

Not sure if you remember the problem we had with Daylight Savings Time last year - but basically when adding jobs to the queue they have a time when they should be processed - and most times this time is "now" or the current time.  Well with the DST problem "now" was actually set in one hour's time - so some jobs just sat there for a while.

We have seen a couple of recent cases where time differences between servers can give this same problem.  A server puts a job on the queue and the timestamp for "now" gets set a couple of minutes in the future - because the SQL Server machine doesn't have the same time as the Project Server machine.  When the queue gets to this job it will just let it sleep until the right time arrives.  This can look like a slow queue, when in fact it is doing what it is told.  Keeping your servers clocks in sync will avoid this problem.  The ULS logs will show this as jobs sleeping when there does appear to be any reason.  In most "sleeping" cases the reason appears in the log - such as a missing custom field in the reporting DB will put a project reporting publish to sleep.

Technorati Tags: Project Server 2007

Posted: Friday, February 08, 2008 3:49 PM by BriSmith

Comments

Sonya said:

OMG!  Brian - you are a genius!  Thanks!  We exerienced crazy 2 min slowdowns for each step in the publish process (2 min for saving, 2 min for publishing, 2 min for checking in, and 2 min for clearing the local cache....an 8 min terrible process).  Thanks for rescuing us!

Ever so grateful,

Sonya

# February 11, 2008 12:56 PM

Christophe Fiessinger's Blog said:

Lately I’ve heard a few requests to improve the Project Server queue performance. For instance some of

# March 21, 2008 5:14 AM
Leave a Comment

(required) 

(required) 

(optional)

(required) 

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Page view tracker