Slow Consolidated Project Load

[Conrad Santiago]

I know this is a long shot; but we are stumped and want to see if anyone has
had the same problem and (fingers crossed) has a solution.

I use a consolidated project to balance the work for the team on a daily
basis. Recently, I've noticed a slow down in the time it takes to load the
50 - 60 projects into the consolidated project. Originally, it was taking 20
minutes to load the projects. It now will take as much as 1 hour and 40
minutes to load. Oddly, though, every now and then, we'll get a day in which
it takes 20 minutes again.

Has anyone experienced this behavior with consolidated projects?

We've been rebooting servers, installing service packs and updating drivers;
nothing is having much affect. The only thing that seems to work is when we
reboot both the Project Server and the SQL Server. (Rebooting only one
server has no effect.) However, the effect is short term and will last a day
or two.

Thanks in advance for any input on this.

Conrad Santiago

 

[Paul Conroy]

I'm sure thaty you're pushing the limits of the application in doing this.

There is so much that can effect the time of this operation. Below are some
of the key points:

Make sure you're using 64bit SQL and Project Server(2007 only)
Project Server Database should have their own LUN (15k drives)
Project Server should have it's own SQL Server (not shared with other apps)
TempDB should have a file for each logical/virtual CPU
SQL Indexes should be rebuilt regularly and statistics updated
Be mindful of other Operations (transactions will be slower if the cube is
building, indexes are rebuilding, other long queries are being run)
Performance will also be affected if you have a deep nested RBS and you're
user account is at the top of the tree and you're using dynamic category
permissions.

You could achieve most of you're requirements without creating a master
project. Using custom fields to create relationships between projects
(Programs), you can create some very detailed reports from the Reporting DB
or Cube.


--
Please rate this post if it has helped

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

http://theprojectserverguru.spaces.live.com

 

[Gordon]

Hi Conrad,

In addition to what Paul is mentioning have you applied SP1 for PS2007.