Re: Retrieving Reposity Structure....

Brandon Casci wrote:
> I then started up my pc, and logged into the Vault client like normal...and
> it sat there and did something for several minutes once it hit "Retrieving
> Reposity Structure....". Everyone else had the same problem too.
> 
> Once our sessions are established, we can shut down Vaul, and start it back
> up again..and we'll be in our repository in just a few seconds. If you let
> the session timeout (20 minutes or so), you have to go through the
> "Retrieving Reposity Structure...."  process again.

I've talked with Jeff Clausius and he thinks it might be a problem with
Vault not expiring old sessions.  This causes the table that stores
session information (specifically which things have been checked out
during the session) to grow really large.  When the client asks for
the new checkout list (after the repository delta is retrieved, but the
status bar still says "Retrieving Repository Structure"), the
server spends too long running the query.

If there is little to no network activity during the time when Vault is
waiting, this is more likely the problem.

Jeff asks that you run the following SQL query on the sgvault database
to verify this cause:

SELECT COUNT(*) FROM sgvault.dbo.tblsessions
SELECT COUNT(*) FROM sgvault.dbo.tblsessionrellocks

-- 
Shaw Terwilliger <sterwill@xxxxxxxxxxxxxx>
SourceGear LLC