1 Reply Latest reply: Feb 18, 2009 11:22 AM by 690399 RSS

    Sybase Database Management

    690399
      Currently we are using Sybase DBs for Contract Manager.
      Since they have given us no issue we stayed with them.


      For those of you who use Sybase do
      you archive projects?
      Do you create new dbs
      each year?
      How large do you let them
      get?
      Should we move to SQL Server? <br
      />
      Thanks
        • 1. Sybase Database Management
          690399
          We also use Sybase for CM 11.1. About 8-12 months
          agowe experienceed showstopping performance hits in
          Contract Manager. After months of work with Primavera,
          including very high level technical people on site,
          Primavera tuned our databases to the point where CM
          worked again. It was a very painful process.<br
          />
          To answer your questions:<br
          />
          For those of you who use Sybase do
          you archive projects?
          <font
          color=red>Yes, to a database (group)that we use
          specifically to store archived projects. This database
          is started when the Sybase server boots so we can
          access the archived projects as well a production
          projects.</font><font
          color=red></font>

          Do
          you create new dbs each year?
          <font
          color=red>No. The onlky consideration, at this
          point, for creating a new database is for operational
          purposes.</font><font
          color=red></font>

          How
          large do you let them get?
          <font
          color=red>As large as they can get before hitting a
          performance problem. Our largest is currently around
          3GB. So far we have not had to split databases because
          of performance. We resist doing that due to the
          associated increase in overhead administering the
          addn'l databases and cross database reporting
          issues.</font><font
          color=red></font>
          <br
          />Should we move to SQL Server? <br
          /><font color=red>If our IS shop were with us
          on this, we would.</font><font
          color=red></font>