Save Jobs Proccesses 95% - 97%

[john]

Hello Everyone,

When I am trying to save larger project files in Project Server 2007, the
job will get to a 95% state and sit for 25 minutes or so before it completes.
Other times the job may get to 97% and I will eventually have to cancel the
job.

I have lowered to 2 queue threads.

Has anybody experienced this before?

Thanks in advance

 

[Darrell]

John,

I had one PM with a schedule that took hours (4 to 6hrs sitting at 97%) to
go thru the queue. What I found was tons of tasks in his schedule with a
duration and no work or resource (D=W/U division by zero), or a duration with
no work and a resource, etc (I think some were caused by improper PWA updates
and some by the PM himself). The PM had also cut and pasted these same tasks
over and over and now his 4000 task schedule was full of corruption. I had to
export to XML and re-import and then go thru and fix all of the remaining
corrupt tasks. After that the same schedule would go thru the queue in less
than 10 minutes. Point is it may be the quality of the schedules and not the
server.

Darrell

 

[john]

Hi Gary,

Yes, we are on SP3 for SQL 2005, Infrastructure Update for Project on the
MOSS Server.

Do you have any other ideas?

This has been an interesting one to dissect.

Thanks
John

 

[john]

Thanks Darrell,

I have a hard time thinking it is due to project corruption since I created
it on the server. The schedule has roughly 3500 tasks with FS dependencies,
I have not yet resource loaded it. I just noticed after 20 minutes it went
from 95% - 96%.

Do you or anyone else have any other suggestions?

I appreciate it,
John

 

[john]

The Job just finished after 25 minutes. How can I improve on this time?

2 Server Windows Server 2003 64Bit environment;

WFE\APP 2GHZ, 3.75 GB RAM - Virtual
SQL Server 2.66 GHZ Dual Quad Proc, 32GB RAM - Physical


Thanks for suggestions,
John

 

[john]

HI Gary,

The file took 25 min to save. When I click save again it saves in a flash.
When I increase the duration and save, the job cruises to 95% but then chokes
on it from there. I am running some sql traces now.

Do you have any ideas or ran into this before?

Thanks
John

 

[Tao of Project]

HI Gary,

The file took 25 min to save.  When I click save again it saves in a flash.  
When I increase the duration and save, the job cruises to 95% but then chokes
on it from there.  I am running some sql traces now.

Do you have any ideas or ran into this before?

Thanks
John








- Show quoted text -

I had this problem before. I forgot the root cause of the problem. You
can delete the project from Published Database only and resave and
republish.

 

[john]

Hi Toa,

Thanks for the tip, but we have many large files with a lot external
dependencies, task custom fields and deleting the project from publish would
not be good.

Jobs for large projects are still stuck at 95% for a long time.

Does anybody know if a CU or SP2 will address the performance?

THanks in advance,
John

 

[Gary L. Chefetz]

John:

If this is taking 20 minutes without resources, something is wrong with the
file. Try saving it as an mpp file to the hard drive, and then use the
import wizard to move it back to the server. See if that improves the save
time.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

 

[john]

Hi Gary and Everyone,

I applied the FEB CU and the performance has tremendously improved. Their
was a TASK CUSTOM FIELD fix in it, looking through SQL that VIEW and Indexes
were poorly designed.

Thanks again everyone for your advice I really appreciate the value of this
newsgroup.

Regards,
John

 

[Gary L. Chefetz]

In fact, in some situations you need to apply a custom execution plan. Let
us know if the problem resurfaces.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com