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:
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.
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.
This is a great checklist, but it's dated 2012. Is there anything different for the current releases?