SourceGear Support

1) Will deploying IIS and SQL on separate servers help? it depends on how much memory is in your current server. however, i don't believe this will help your situation. 2) Can large mutates be reduced to sub-minute and moderate ops be reduced to seconds w/o splitting our current repository? Our cur...

normal database maintenance varies based on number of users, distribution of data, imported vss databases, deleted repositories, etc. here is the "jeff clausius rule of thumb for database maintenance": 1) UPDATE STATISTICS for all tables every sunday morning - note by default the sgvault d...

ok... i see. it seems iis 6 uses some sort of "ping" model to determine if the iis process is "unhealthy".

thanks for the update.

ok... that eliminiates the possiblity of an existing bug.

Within IIS' manager, check the properties on the default application pool (assuming no-one has configured Vault to use a separate pool).

The deadlock interval's equivalence is "Shutdown worker processes after being idle for (time in minutes)".

HTH

by chance, have you moved the "SourceGear Vault" shortcut from your Start Menu?

Note: Vault Server 7.0 requires .NET 4.5 and is not supported on Windows 2003 Server. Before installing Vault on a Windows 2003 Server, Internet Information Services and ASP.Net to be installed and configured. 1) Verify ASP.Net is installed. From the Control Panel -> Add / Remove Programs, click &q...

Matt:

There were some history adjustments to make room for snapshots vs. labels. If your database has been maintained with the proper maintenance, it shouldn't take too long to make the adjustments - (minutes or less).

a little more info.... here is an excerpt from the vault server sql ddl, and a small description for each history enumeration: --****** object: user Defined datatype uhistorytype Script date: 7/8/2002 9:43:13 AM ******-- -- ENUM -- Added = 10; // Added (on the parent folder for the created item) -- ...

joel: i would recommend upgrading to vault 2.0 as soon as you can fit it within your schedule. we fixed a number of concurrency issues in the 2.0 release, which should improve your overall performance. if you do happen to upgrade, and are still experiencing blocking issues, please let us know, asap....

keith: this may or may not solve your problem: from the menu -> tools -> add in manager. highlight the source code control item, and make sure "load on startup" and "loaded/unloaded" are checked. additionally, you may want to check your vbaddin.ini file. there should be some sort...

'Umm, too many negatives here - "i'd recommend against **NOT** using any of the backup routines"' doh! - its late... sorry about that. basically, the admin tool will try to backup the 'sgvault' database. if you have two distinct 'sgvault' databases (due to named instances for example), the...

gaffa: if i understand correctly, you are saying you will have *two* vault databases and two vault web services located on the same machine? is this correct? maybe i've misread your posts. in most cases this will work just fine. however, i'd recommend against **NOT** using any of the backup routines...

gaffa: basically, everything related to vault operations is pretty much self contained within the sgvault database. the steps would be: 1) detach 2) copy all files associated w/ the database (sgvault.mdf, sgvault.ldf, etc) to new sql server 3) attach database files there, that wasn't so bad was it? ...

Summary: Installing Vault Server on a Windows Server 2003 running in "IIS 5.0 isolation mode" produces the following error in the Vault Server's log file: "CryptoAPI cryptographic service provider (CSP) for this implementation could not be acquired." Additionally, the Vault Clien...