Queue Sluggish

[Trisha]

I have the documentation for the Project Server 2007 Queuing System but can
anyone tell me off the cuff why it would take 2-5 minutes for the Project
Server 2007 Queue to process a single job?

 

[Gary L. Chefetz [MVP]]

Trisha:

Check to see if the server time on the PWA box matches the server time on
the SQL box. If the SQL server was a bit behind the PWA box, it could delay
the processing.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[Paul Conroy]

In additional to Gary's comment you also need to consider overall SQL
config/performance. If SQL is poorly configured and or under resourced then
Project Server will not perform as expected.

Here's a list of counters to help you understand whether SQL is performance
as it should be

http://theprojectserverguru.spaces.live.com/Blog/cns!D74683E5EE2E06E2!350.entry

Often overlooked when configuring SQL is the creation of a separate TempDB
file for each CPU presented. Project Server is a heavy user of the TempDB
and there is is only one DB file then only one thread can process against it
at anyone time.

http://msdn.microsoft.com/en-us/library/ms175527.aspx

Ensure the database have sufficient space. All to often I see database
created at low initial size with 1MB increments. SQL stops IO to the DB when
auto growing the files. This also impacts on the fragmentation of the file
and therefore the performance of queries.




--
Please rate this post if it has helped

http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com