Where the professionals network; have you Self Assessed? become a Guild Reviewer? or reviewed Guild Phase 2?

P6 locks up or is very slow when loading schedule

11 replies [Last post]
Chris McMillan
User offline. Last seen 51 weeks 6 days ago. Offline
Joined: 21 Jul 2010
Content Credits: 5
Hello fellow planners,

I have a BIG issue. I have been running P6.2 standalone for two years with SQL. Yesterday, I could not open P6 at all. I reloaded SQL, I reloaded P6, and I verified my database configuration. Now, I can open P6 but my small schedules take very long (5 minutes) and my large schedules 4000+ tasks don’t load at all. P6 just sits there acting like its loading but does nothing. I received an error message yesterday about "shared memory". has anyone encountered this problem before? Any solutions?

Thanks!

Replies

Simon Toner
User offline. Last seen 12 weeks 23 hours ago. Offline
Joined: 24 Jun 2005
Content Credits: 10

I realize that this is years after this string was started; but I have used the fix suggested by Keyel and it has solved my problem.  My loading time has gone down from 15-20 mins to about 5-10 seconds.

Thanks

Bernice Nguyen
User offline. Last seen 41 weeks 6 days ago. Offline
Joined: 22 Jul 2011
Content Credits: 4
Groups: None
Levitra mausoleum Drover Buy Tramadol nosh adenocystomata Tizanidine 4mg impetuosity diploneural Buy Cialis Blows peck
Keyel Isorena
User offline. Last seen 1 week 1 day ago. Offline
Joined: 31 Oct 2006
Content Credits: 41

I manage to try this in one of our PC and this http://primaveratools.com/Portals/PrimaveraTools/activeforums_Attach/001_slow_performance_P6.pdf works perfectly. Just use the windows authentication instead of the sql server authentication since our P6 is on a stand alone version. hope this helps.

 

Cheers,

 

Keyel

Keyel Isorena
User offline. Last seen 1 week 1 day ago. Offline
Joined: 31 Oct 2006
Content Credits: 41

Chris, Have you tried this http://primaveratools.com/Portals/PrimaveraTools/activeforums_Attach/001_slow_performance_P6.pdf? I cant try it since it needs an "SA" account and I have to ask our IT to do it for me. If you can try this and it helps, please provide feedback so we can suggest that this is a solution. BTW, in the forum where I found it, it says that it has to be redone every time the system slows down on loading again.

 

Regards,

 

Keyel

Keyel Isorena
User offline. Last seen 1 week 1 day ago. Offline
Joined: 31 Oct 2006
Content Credits: 41

Rodel, I am having the same problem as with Chris. I have checked the Primavera background agent and verified that it is running and that it starts automatically. Question is, is there a way to verify that the Symon and Damon are actually running, or better yet can we make it run everyday instead of weekly?

Keyel

Keyel Isorena
User offline. Last seen 1 week 1 day ago. Offline
Joined: 31 Oct 2006
Content Credits: 41

Chis, I think I have the same problem as you have. We are running on a stand alone version of P6 6.1 on a 2.66 Ghz intel quad core with 4 GB of RAM running windows 7 32 bit. Our project having 9000+ activities loads but it takes about 20 minutes to load. Have you found a solution yet?

 

Keyel

Rodel Marasigan
User offline. Last seen 5 hours 29 min ago. Offline
Joined: 25 Oct 2006
Content Credits: 1516
Chris,
Yes it can, refer to your Primavera Admin Guide. I believed Damon run every Saturday by default.
Chris McMillan
User offline. Last seen 51 weeks 6 days ago. Offline
Joined: 21 Jul 2010
Content Credits: 5
Is there a way to manually run the system monitor and data monitor? My background agent is running but I think my memory is full.
Rodel Marasigan
User offline. Last seen 5 hours 29 min ago. Offline
Joined: 25 Oct 2006
Content Credits: 1516
Chris,
It might be and your memory is not enough. It will not compact immediately. Cleaning will be done weekly so I’m not sure when the last run was. Observe for one week if still the same otherwise consult your IT to change the settings to daily and once it run smoothly change it back to weekly.

Note: Background agent is running I think because you said you just reinstall SQL again which just update the driver and run which means does not clean up the system.


Chris, another suggestion is creates another database and run using another database. You might find that new database is running fine. You can access any of these databases anytime.
Chris McMillan
User offline. Last seen 51 weeks 6 days ago. Offline
Joined: 21 Jul 2010
Content Credits: 5
Rodel,

Thank you for your response. My Background agent is running. However, I restarted it and the problem remains. Could my database just be too big?
Rodel Marasigan
User offline. Last seen 5 hours 29 min ago. Offline
Joined: 25 Oct 2006
Content Credits: 1516
Chris,
Check if Primavera Background Agent is running. (Select Start-> Settings-> Control Panel-> Administrative Tools-> Services. Look for Primavera Background Agent and double click. Click start if the status is not started. Also set Start up Type to Automatic.) The use of this service is to run SYMON (System Monitor)run daily and DAMON run weekly(Data Monitor). These two programs running in the background to clean up system and data (i.e. log files, caches, deleted files and recorded action for undo’s) If Background Agent is not running then PC will slow down and memory will be full.

Hope this help.