How To...Reduce Vault Size and Generally Improve Vault Performance

Follow these steps to reduce the size of the Vault and improve performance 

1. (Server) Run an SQL maintenance plan as per the Advanced Configuration Guide
2. (Client) Delete unwanted files\folders
3. (Client) Change the "Thumbnail" property to "Not In Use" and Reindex Properties
4. (Client) Change any other unwanted Properties to "Not In Use" and Reindex Properties. The biggest benefit will be those with high Usage counts. 
5. (Client) Delete unwanted "Obsolete" Items (Productstream\Vault Manufacturing\Vault Proferssional Only)
6. (Server) Purge unwanted versions. RULES OF PURGING
7. (Server) Run a property reindex
8. (Server) Run an SQL maintenance plan (Again) as per the Advanced Configuration Guide
9. (Server and Clients) Remove the IPv6 from all clients and the server.

Running the SQL Maintenance plan at the beginning is to hopefully make the following steps easier, then once all the steps are carried out, run it again.

NOTE!! If you are concerned about the amount of time that it takes to backup your Vault using the ADMS Console, it might be time to upgrade to Vault Collaboration or Vault Professional 2011. Both have the capability to perform Incremental and Hot Backups. The first Incremental backup just backs up the difference between the last full backup, the second Incremental backup takes the difference since the previous Incremental backup, and so forth. A Hot Backup allows users to access the vault and write to it whilst the backup continues.

Client Side - Grid Population\ Folder Navigation performance suggestions

Remove the following property columns from the client grid display

• "Thumbnail"
• "Property Compliance"
• "Vault Status"

These properties provide useful (but arguably not critical) information to the user. Some are calculated dynamically and will differ from one user to another in almost realtime. The effect of displaying these properties is that it perpetually requests information from the server and slows down Vault for all users.

 

Note: client side performance problems can also happen if the proxy settings are set incorrectly

Comments

[Peter]

Again - good stuff, but thumbnails are a system property in Vault 2011 and therefore NOT removable. I would love for you to tell me I'm wrong because the thumbnails "bloat" the database and I would happily purge them if I could.

[hooking]

wew! that's quit an interesting post! this properties truly provides important information to the user.