SourceGear Support

When I started I had zero items in my pending change set. The first merge took ~8 minutes to complete at 0. The rest took about the same amount and my pending change set count went up to 10.

My Vault version is 3.1.0 (3494) on both the client and server.

Oh and there's roughly 800 checkouts in this repository right now (if that helps any).

I enabled logging and did a merge that had only a single file from a single folder. I have nothing in my change set except 3 other merges for a total of 9 modified files and 3 added files (all from the same $/Branches/R&D folder). Source: $/Branches/R & D - Worfklow Service Providers/Globera...

So I've been doing a few merges lately and they've been relatively unbearable. I go through the wizard and everything happens quickly (get, compare, merge) then when it gets to the final step "Adding items to your pending change set" it takes a ridiculous amount of time to complete. The UI...

Well here's the trace file. spgetlockedfilechanges takes about 14 seconds to run, and it happens on getting the repository, checkout and undo checkout. Also note that sqlserver.exe goes to to 25% CPU usage (the max it pretty much ever has with the 4 procs taskmgr reports me as having) for the entir...

The 15+ seconds is when folder security is disabled? That is surprising. :shock: I'll await for your first profile run. Not only is folder security disabled on that repository, but I removed my account from all groups (so there should be no security applied to my account whether it's checked or not).

Well here's the trace file. spgetlockedfilechanges takes about 14 seconds to run, and it happens on getting the repository, checkout and undo checkout.

jclausius wrote:Is it safe to assume checkout / checkin performance is acceptable with security disabled?

No.

asills wrote:I have folder security disabled right now. I disabled it the moment we saw performance problems.

It's been disabled for days now.

Yes. It's disabled, just letting you know however that there are security groups applied to every user, but the repository folder security option is off.

One other thought - Has the user account been denied any part of the tree? Can the denial rights be removed or at least set to read-only? If you do remove denied rights, does that help performance of checkouts? I have folder security disabled right now. I disabled it the moment we saw performance p...

No, nobody checks out entire folders to edit single files. Well, that's not entirely true, since Installshield 8 is a big POS and its source control "integration" effectively exports all the various portions of a merge module/installer into about 120 separate files. In order to edit anythi...

So here I am a while later and the Vault server's performance has degraded significantly. It was great for a few days then today it has taken upwards of 5 minutes to complete a checkout and two or three times that long to complete a checkin. I ran the suggested sql commands again and I'm down to 40 ...

I don't think we could have done hundreds of thousands or millions of checkouts. We're in a pretty active development cycle and have probably 80 projects with an average of 25 files per project, plus a few branches plus about 75 installshield merge modules (which end up being like 110 files in the s...

If you try the operations, are you still blocked now? NO! I can checkout/checkin/undo perfectly now. Thank you! Now, can you by chance tell me any more info and/or what we just actually did so I can communicate to the team what they need to do if anything (such as we just deleted their checkout lis...

9 seconds that time