Show History suddenly becomes very slow

[stevek2]

We're seeing some very weird slowdowns with retrieving Vault history on one of our repositories -- something like 4 minutes to retrieve <2500 history items, when the other repositories (10000 items) takes 17 seconds. Our repository looks as follows:

$/
/abc
/def

A history operation on $/def, or on the top-level $/, works very quickly. But retrieving history on $/abc is very slow. This is particularly surprising when a history of the parent root-level $/ is not similarly slowed down!

I enabled Debug logging on the server, but it didn't show anything interesting -- a snippet is included at the end, but basically it's just showing that the "DB: QueryHistory" takes 3.5 minutes to run. Running Show History on $/ takes about 5 seconds.

Two last notes --
-- we did an obilterate earlier today on a sibling of $/abc. I could see maybe that would affect $/, but why $/abc ?
-- I've tried iisreset, and restarting SQL server, and running a CHECKDB on sgmaster/sgvault, all with no effect.

This is on Vault 4.1.3. Any thoughts on what's happening?

Steve



----11/3/2008 4:18:55 PM stevek--LBSTEVEK(10.21.0.216)--SSL Disabled ASMX: BeginHistoryQuery started.
----11/3/2008 4:18:55 PM stevek--LBSTEVEK(10.21.0.216)--SSL Disabled DB: GetUserRepositoryLastChange started.
----11/3/2008 4:18:55 PM stevek--LBSTEVEK(10.21.0.216)--SSL Disabled DB: GetUserRepositoryLastChange finished.
----11/3/2008 4:18:55 PM stevek--LBSTEVEK(10.21.0.216)--SSL Disabled DB: GetLatestRepositoryInfo started.
----11/3/2008 4:18:55 PM stevek--LBSTEVEK(10.21.0.216)--SSL Disabled DB: GetLatestRepositoryInfo finished.
----11/3/2008 4:18:55 PM stevek--LBSTEVEK(10.21.0.216)--SSL Disabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 6898
----11/3/2008 4:18:55 PM stevek--LBSTEVEK(10.21.0.216)--SSL Disabled DB: QueryHistory started.
----11/3/2008 4:22:16 PM stevek--LBSTEVEK(10.21.0.216)--SSL Disabled DB: QueryHistory finished.
----11/3/2008 4:22:16 PM stevek--LBSTEVEK(10.21.0.216)--SSL Disabled BeginHistoryQuery returned: Success
----11/3/2008 4:22:16 PM stevek--LBSTEVEK(10.21.0.216)--SSL Disabled ASMX: BeginHistoryQuery finished.
----11/3/2008 4:22:17 PM stevek--LBSTEVEK(10.21.0.216)--SSL Disabled ASMX: GetHistoryQueryItems started.
----11/3/2008 4:22:17 PM stevek--LBSTEVEK(10.21.0.216)--SSL Disabled GetHistoryQueryItems returned: Success
----11/3/2008 4:22:17 PM stevek--LBSTEVEK(10.21.0.216)--SSL Disabled ASMX: GetHistoryQueryItems finished.

[lbauer]

If you Show Labels on $/abc, are there a lot of labels? If so, that could be slowing down the history display.

[stevek2]

No, there are only about 5 labels.

[lbauer]

Is there anything remarkable about that folder or subfolders, in terms of their complexity: are there a lot of nodes, branches, shares, etc.?

[lbauer]

We'd like to troubleshoot this in depth. Contact me at support at sourcegear.com, Attn: Linda, and provide a link to this post.