Vault performance degradation

ISBEPGR · Post by **ISBEPGR** » Thu Oct 13, 2005 12:50 pm

Vault performance seems to be waining as time goes by. Most of my users are just experiencing a slow down. For one user, the client hangs when trying a check-out, diff, history or resolve merge status. Vault is unusable for him. Please let me know what I can do to fix this.

Vault = 3.0.7
Client OS=Windows XP
VB6 and VSNET 2003

lbauer · Post by **lbauer** » Thu Oct 13, 2005 12:53 pm

The first suggestion would be to upgrade to 3.1.2, as we have made performance enhancements.

Next, run database maintenance if you don't already:
http://support.sourcegear.com/viewtopic.php?t=2924

If you've been using Vault for a while, review your hardware to make sure you still have adequate resources for your current Vault usage and space requirements.

ZackJones · Post by **ZackJones** » Thu Oct 20, 2005 5:00 am

Linda,

Could you folks please publish a similar KB article, with SQL commands, for optimizing our sgdragnet datbase. I just ran all of the scripts for our vault database and has seemed to perk things up quite a bit

Thanks!

Zack

lbauer · Post by **lbauer** » Fri Oct 21, 2005 9:05 am

Thanks for the suggestion. We'll put in on our To-Do list.

lbauer · Post by **lbauer** » Wed Nov 02, 2005 2:42 pm

Update:

We now have a KB article for Dragnet database maintenance:
http://support.sourcegear.com/viewtopic.php?t=5000