Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Blog Database Maintenance for ProjectWise
    • Sign In

    ProjectWise Product Advantage
    ProjectWise Product Advantage
    Thu, Dec 20 2012
    • ProjectWise Administration
    • Oracle
    • ProjectWise
    • SQL

    • Share
    • Subscribe by email
    • More
    • Cancel
    • August 2022 (1)
    • December 2020 (1)
    • July 2020 (1)
    • July 2019 (1)
    • November 2017 (1)
    • October 2017 (2)
    • July 2017 (1)
    • June 2017 (2)
    • April 2017 (1)
    • February 2017 (1)
    • January 2017 (2)
    • December 2016 (1)
    • October 2016 (1)
    • September 2016 (2)
    • July 2016 (1)
    • June 2016 (1)
    • April 2016 (2)
    • March 2016 (1)
    • February 2016 (2)
    • January 2016 (1)
    • December 2015 (2)
    • November 2015 (2)
    • August 2015 (2)
    • July 2015 (1)
    • June 2015 (3)
    • April 2015 (3)
    • March 2015 (2)
    • February 2015 (1)
    • December 2014 (1)
    • October 2014 (3)
    • August 2014 (1)
    • June 2014 (1)
    • May 2014 (3)
    • March 2014 (1)
    • November 2013 (2)
    • October 2013 (4)
    • September 2013 (2)
    • August 2013 (4)
    • July 2013 (6)
    • June 2013 (6)
    • April 2013 (8)
    • March 2013 (9)
    • February 2013 (3)
    • January 2013 (4)
    • December 2012 (5)
    • November 2012 (6)
    • October 2012 (3)
    • September 2012 (4)
    • August 2012 (7)
    • July 2012 (4)
    • June 2012 (6)
    • May 2012 (2)
    • April 2012 (5)
    • March 2012 (2)
    • February 2012 (4)
    • January 2012 (2)
    • December 2011 (3)
    • November 2011 (2)
    • October 2011 (4)
    • September 2011 (4)
    • August 2011 (5)
    • July 2011 (5)
    • June 2011 (5)
    • May 2011 (4)
    • April 2011 (6)
    • March 2011 (5)
    • February 2011 (4)
    • January 2011 (8)
    • December 2010 (10)
    • November 2010 (4)
    • October 2010 (3)
    • September 2010 (6)
    • August 2010 (7)
    • July 2010 (6)
    • June 2010 (6)
    • May 2010 (3)
    Related
    Recommended

    Database Maintenance for ProjectWise

    We get asked a lot what kind of database maintenance or things to keep in mind that a user should do on their ProjectWise system's database.  These should be basic tasks that a database administrator would take care of, but sometimes that is not the case.  Below are some areas that you will want to focus on:

     

    Memory

    • Make sure your database is using as much memory as possible.  Sometimes a database will be setup with 16gb of RAM but it is only utilizing 2GB of that RAM for the database.  You will want to make sure that your dba has as much memory allocated to the database as possible.

    Disk

    • Disk optimization can greatly increase SQL Server performance when managed correctly. Removing old backup files to a file-server or network share can increase available disk space needed for transaction logs, database files, and indexes.

    Backup

    • Regular backups of the transaction logs help to keep the transaction log's size low, which within a database they can grow quickly and consume all the available space allocated to the db.
    • The backup process truncates old log records no longer needed for recovery and marks them as inactive so they can be overwritten. Implement a good backup strategy consisting of full database backups, transaction log backups, and system database backups.

    Indexes

    • A scheduled task to rebuild your indexes is easy to set up and can keep ProjectWise running smoothly.  We have some users that rebuild them once a week and some that rebuild them once a day.  Depending on how much your datasource is used will depend on how often you want them rebuilt.
    • It is recommended to rebuild an index that is over 30% fragmented and reorganize when an index is between 10% and 30% fragmented. Rebuilding a fragmented Index is most advantageous if the index contains at least 100 pages, otherwise you may not see any difference after a rebuild is performed if the Indexes are small.

    Update Statistics

    • It is recommended to update the statistics if the results show an outdated date in the “Updated” column and/or if there’s a substantial difference between the “Actual Number of Rows” and the “Estimated Number of Rows” in that table. You can view the table properties get the “Actual Number of Rows” from MicroSoft SQL Server Management Studio.
    • Updating statistics can also be an automated task, our users normally update statistics and rebuild indexes on the same schedule and it is just as easy to setup as rebuilding your indexes.

    I/O distribution Analysis for Performance

    • Analyze the I/O of your system and decide the best distribution for the I/O load. Perform object level analysis and do performance tuning at table level. The goal is to reduce I/O performance bottlenecks and set optimal setting for read and write database.

    If you have any further questions or need clarification please let us know and we will be glad to help.

    • Sign in to reply
    • skeller
      Offline skeller over 7 years ago

      Thanks!

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • More
      • Cancel
    • Molly Watts
      Offline Molly Watts over 7 years ago

      skeller , this information is all still valid up to the latest releases of ProjectWise

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • More
      • Cancel
    • skeller
      Offline skeller over 7 years ago

      This is a great checklist, but it's dated 2012.  Is there anything different for the current releases?

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • More
      • Cancel
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies