Skip to content
ProjectControls.com
Oracle Primavera - PM6

Recent upgrade to Primavera 6.7 SP1 – huge SQL transact

In the Open Standard
Stuart FairweatherMember for 16 years 6 months
Created
1
3
0
We’ve recently upgraded from Primavera 5.0 SP7 to 6.7 SP1 and we’re having major issues with the database transaction log (we’re using SQL Server 2005 running in 2000 compatibility mode). If we truncate the log it remains small for a few hours then starts to grow and within the space of a day it fills the server hard drive – 13GB in our case. Has anyone had similar problems? We didn’t have this problem when we were on P5 and no hardware or DB configurations have changed. The SYMON job appears to be running every minute as it should and we’ve scheduled DAMON to run daily (default 1 week).

Cheers
Save Follow Follow forum Report
Reply New topic

1 reply

Oldest first
  1. 0
    Rodel Marasigan ·
    #1
    Stuart,
    P5 has a compact database function which is removed in P6.x to P6v7.
    This was the function of SYMON and DAMON.
    SYMON (System Monitor), responsible for running procedures that take less than a few seconds to complete. (default every minute)
    DAMON (Data Monitor), responsible for running procedures that take longer than a few seconds to complete. (default weekly)

    For log files I’m not too sure because I haven’t experience that yet but I’m sure it nothing to do with those system and data monitor that you mentioned.
    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?