How big is your sgvault Database?

This forum is now locked, since Gold Support is no longer offered.

Moderator: SourceGear

Posts: 288
Joined: Wed Dec 22, 2004 11:10 am

How big is your sgvault Database?

Post by Tri » Thu Oct 27, 2005 9:13 am

Do any of you has concerns about the growing size of your sgvault DB? Big size takes more time and space for back ups.

I wish to use Vault server for codes and small documentations that support the codes. As users get used to Vault, some find convenient to use Vault as a LAN storage device. They check in big binary files like DB backups, video or big PDF. In addition, most of the users are not aware that a deleted file still consumes storage space in Vault server.

I would appreciate any advice on the good practice to manage these big binaries.

Thanks very much in advance.

Posts: 38
Joined: Mon Nov 01, 2004 10:06 am

Post by nmcalpin » Wed Dec 14, 2005 10:49 am

Sometimes our developers like to do the same thing (use vault as LAN storage and check in large to huge to gargantuan files).

would be nice to have an official statement/recommendation from SG on this one.

Posts: 38
Joined: Mon Nov 01, 2004 10:06 am

Post by nmcalpin » Wed Apr 12, 2006 10:55 am

SourceGear? any input?

Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » Wed Apr 12, 2006 1:50 pm

It's difficult to have an official answer when much depends on user preferences.

A large database is not necessary a problem. Technically, Vault database size is limited only by SQL Server limits. We have customers with databases of 160 GB and more. However, as Tri said, you need adequate hardware and disk space when your database grows. You should be doing regular database maintenance.

But Vault performance depends more on how many users/transactions/checkouts there are, rather than database size.

Some users use Vault only for source files, and archive large binaries elsewhere; other users like to have everything in one database.

Use Vault in the way that best meets your needs.
Linda Bauer
Technical Support Manager