RE: Retrieving Reposity Structure....

Ok. Here are the results...

SELECT COUNT(*) FROM sgvault.dbo.tblsessions
Result : 34

SELECT COUNT(*) FROM sgvault.dbo.tblsessionrellocks
Result : 4128

-----Original Message-----
From: Shaw Terwilliger [mailto:[email protected]]
Sent: Wednesday, January 28, 2004 10:41 AM
To: Brandon Casci
Cc: [email protected]
Subject: Re: [vault-list] 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 <[email protected]>
SourceGear LLC

Get the latest news on SurfControl and our products,
subscribe to our monthly e-newsletter, SurfAdvisory at:
http://www.surfcontrol.com/resources/surfadvisory/surfadvisory_signup.aspx

*********************************************************************
The information in this email is confidential and may be legally
privileged. It is intended solely for the addressee. Access to this
email by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution or any action taken
or omitted to  be taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email in error,
please contact the sender.
*********************************************************************
SurfControl Inc.
100 Enterprise Way, Suite A110
Scotts Valley, California 95066
831-440-2500