Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

My P6 is very slow

7 replies [Last post]
Wed, 2012-04-11 06:44
hosam ebrahim
User offline. Last seen 12 years 1 week ago. Offline
Joined: 17 Oct 2011
Posts: 19
Groups: None
Dear Friends
Iam working on Primaver 6 R8.1 - SQL SERVER 2005

my problem is that making any process now take extraordinary time. opening one file take may be 15 minutes, opening 2 files together to make any work take more than 30 minutes. i checked primavera background agent and found it working. also there i got some quiries in PDF file from one friend, i did these quiries but also didnt help.

please r there any method to make working faster i really loose my time now for nothing?

THANKS IN ADVANCE
Top

Replies

Thu, 2018-05-10 13:55
#1
Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

do this

Go to start

All programs

Select Microsoft SQL Server 2005

Then Microsoft SQL Server Management Studio

Server name is the name of your computer\PRIMAVERA

Authentication is SQL Server Authentication

Login: sa

Password is: Prima123Vera

Select Connect

On the left expand the databases and select pmdb$primavera

Uptop select New Query

on the right type this

update statistics project with fullscan ,all
update statistics task with fullscan, all

Then right click execute

Then type

exec sp_updatestats

Then right click execute

Top
Thu, 2018-05-10 13:24
#2
Khuong Do
User offline. Last seen 2 years 3 weeks ago. Offline
Joined: 22 Feb 2010
Posts: 118
Groups: None

Hi,

When using Primavera P6 with Microsoft SQL Server database, we can have problem like this:

  • Loading Data hangs at 98%.
  • Performance issues in SQL Server.
  • Opening projects is slow.
  • PM.exe not responding after entering username and password.
  • Project Management window disappears after loading data.
  • Cannot login to PM, no error.

Here is the solution to solve above problem:

https://doduykhuong.com/2018/05/10/primavera-p6-sql-server-database-slow-loading-data-performance-issue/

Top
Fri, 2018-05-11 11:55
#3
Rafael Davila
User offline. Last seen 18 hours 18 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team

IMAGE DELETED 5/11/2018 AS NO LONGER AVAILABLE ON THIS VERY OLD DISCUSSION THAT FOR SOME REASON WAS RESURRECTED AFTER BEING INACTIVE FOR SIX YEARS.

Make sure you have a backup of your database before it is too late.

Suggest calling ORACLE support team, they are very capable professionals that can guide you to a solution, I suppose although not obvious it shall be an easy solution as P6 is famous for its ease of use, so easy it is their favorite sales pitch.

Best regards,

Rafael

Top
Wed, 2012-04-11 19:44
#4
hosam ebrahim
User offline. Last seen 12 years 1 week ago. Offline
Joined: 17 Oct 2011
Posts: 19
Groups: None

Thanks alot mr Ronald, actually i know about this link and it didnt help i mentioned this in my question

Top
Wed, 2012-04-11 14:47
#5
Ronald Winter
User offline. Last seen 3 years 6 weeks ago. Offline
Joined: 4 Jan 2003
Posts: 928
Groups: None

Hosam,

 To solve your problem, try clicking on the link to the right of your question titled, “P6 locks up or is very slow when loading schedule.”  Good luck!

Top
Wed, 2012-04-11 09:51
#6
hosam ebrahim
User offline. Last seen 12 years 1 week ago. Offline
Joined: 17 Oct 2011
Posts: 19
Groups: None

thanks for reply, but actually i can't delete any of the files which currently exist on my database. but i didnt reach the 4GB Limit till now. iam 3.5 GB now.

Top
Wed, 2012-04-11 09:41
#7
Daniel Limson
User offline. Last seen 4 years 39 weeks ago. Offline
Joined: 13 Oct 2001
Posts: 318
Groups: None

Hosam,

Delete old files you do not use anymore. Back them up and delete (just in case you need them for reference in the future)

Always keep your database lean to keep it running smoothly.

Regards,

Daniel

Top