Skip to content
ProjectControls.com
Oracle Primavera - PM6

P6 Stand Alone Slow performance

In the Open Standard
Sampath Lakshmi NarayananMember for 18 years 7 months
Created
9
6
0
Dear all

Kindly help me in this matter. I have p6 standalone.I am working in multiple projects. Few days it was working good. One fine day every project just opening it self taking 2 hrs time. Then even importing and opening of projects are taking too long time (More than 1 Hr). Kindly suggest me a way to work out.....
Thanks in Advance
Save Follow Follow forum Report
Reply New topic

9 replies

Oldest first
  1. 0
    Arnold Puy ·
    #1
    Hi Sampath,

    1. Try to check your Edit --> User Preferences --> Startup Filters, all mark must be under the "Current date project only".

    2. If you are using windows vista try to change the setting from your Control Panel --> Power Option --> Preferred Plans, then select "High performance".

    3. You can compress or Shrink your database using the "SQL Server Management Studio Express".

    Hope this helps.

    Regards,

    Arnold

    Report
  2. 0
    Sampath Lakshmi Narayanan ·
    #2
    Thank you very much Mr.Arnold. I have checked your first option which is correct. I am using windows xp. Can you tell me whether shrinking of data base will give effect in performance of primavera and should i use re arrage before shrinking...?

    Thank you once agin for ur help

    warm regards
    Lakshmi Narayanan
    Report
  3. 0
    Arnold Puy ·
    #3
    Hi Sampath,

    Based on my experience to my windows xp laptop, shrinking decrease the usage capacity of my database and the performance is quite better than before. I am not sure if you should re-arrange first before shrink. But it works fine without doing that. But, make sure to backup your database.

    Try to reduce the data from your database and just import again the moment you will need it. This is also what I am doing.

    Regards,

    Arnold
    Report
  4. 0
    Sampath Lakshmi Narayanan ·
    #4
    Thank you once again Mr.Arnold.

    Thanks alot for ur technical sugestion. I will try in that way and reply you. Any way so kind of u..

    warm regards
    Lakshmi Narayanan
    Report
  5. 0
    Arnold Puy ·
    #5

    You are welcome..

    Report
  6. 0
    Luca Basile ·
    #6
    Hi
    what I found out that if I import several schedules into the DB after a while it get corrupted and need to re-install a brand new DB

    Generally with the DB corrupted my system performance was very bad


    L

    Report
  7. 0
    Dieter Wambach ·
    #7
    Luca

    Maybe you’ll first try backup and restore. "Corrupt" might be too many extensions of some tables which may lead to "out of memory".

    Regards
    Dieter
    Report
  8. 0
    Khuong Do ·
    #8

    Hi,You can try below

    Hi,

    You can try below solution:

    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:
    Report
  9. 0
    Zoltan Palffy ·
    #9

    do thisGo to startAll

    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

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?