Vault loadup REAL slow

[andrew00]

My vault takes about 2 minutes to start up and initialized the repository. I probably have about 2,000 files in it, with about 200 directories - it doesn't seem like it should be this slow.

Would an obliterate help? I've never performed it on the repository before, and I'm not sure they would make it faster?

[lbauer]

No, obliterate probably wouldn't help. It doesn't sound like your database/repository is particularly large.

Some suggestions:

-- Regular database backup and maintenance is important. See this KB article for details:

http://support.sourcegear.com/viewtopic.php?t=2924

-- File fragmentation can greatly affect SQL Server performance. Database maintenance is more effective when the drives are not fragmented.

To defrag SQL Server machine hard drive:

1) Back up the Vault database to another machine first.
2) Stop the SQL Server and the ASP.NET service so the files aren’t locked.
3) Run defrag on the drive.
4) Start the SQL Server and ASP.NET service.

Also, try setting working directories only for the folders you are working on -- this reduces the amount of scanning Vault has to do to determine the status of files in the working directories.

If you're not already on Vault 3.5.2 or later, upgrade -- we've made some performance enhancements in later versions.