Creating a Label takes 1.5 hours

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
ehudm1
Posts: 5
Joined: Wed Oct 17, 2007 4:17 am
Contact:

Creating a Label takes 1.5 hours

Post by ehudm1 » Sun May 20, 2012 8:40 am

Hi,

Vault Version 5.1.2 (19281).

We are using Labels in our night build. Each build first label the branch and then gets the latest version using that label.
At the beginning, creating a label took reasonable time (few seconds) but now, after we have 200~300 labels in the repository, We found that creating the label takes 1.5 hours!

Can anyone suggest what's wrong?

Thanks,
Ehud

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

Re: Creating a Label takes 1.5 hours

Post by lbauer » Mon May 21, 2012 7:31 am

The first thing I would suggest is to run maintenance on your sgvault database. See the "Database Health" section of this KB article:

http://support.sourcegear.com/viewtopic.php?t=2924
Linda Bauer
SourceGear
Technical Support Manager

ehudm1
Posts: 5
Joined: Wed Oct 17, 2007 4:17 am
Contact:

Re: Creating a Label takes 1.5 hours

Post by ehudm1 » Mon May 28, 2012 3:23 am

Hi Linda,

Thank you for your answer.
I executed CHECKDB and DBREINDEX for sgvault (see attached files) but labeling still takes 1.5 hours.

Other suggestions?

Thanks,
Ehud
Attachments
DBCC DBREINDEX sgvault.txt
DBREINDEX
(9.05 KiB) Downloaded 325 times
checkdb messages.txt
CHECKDB
(12.7 KiB) Downloaded 295 times

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

Re: Creating a Label takes 1.5 hours

Post by lbauer » Mon May 28, 2012 12:08 pm

We'd like to see a copy of the Vault Server log during the time the label is being applied.

It's called sgvault.log and is in %windir%\temp\sgvault on the server machine.

Send the log zipped up to support at sourcegear.com attn: Linda. Include a link to this forum post.
Linda Bauer
SourceGear
Technical Support Manager

Post Reply