Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

VS 2008 slow SSAS solution opening from TFS 2008 Expand / Collapse
Author
Message
Posted Tuesday, March 25, 2014 4:31 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 4:30 AM
Points: 57, Visits: 73
We are experiencing really slow opening times of SSAS solutions from Source Control Explorer in VS2008.
we are using:

-TFS 2008
-Visual Studio 2008 with SP 1.

On a freshly installed machine (Win7 64 bit) the loadings were pretty okay (~2mins, its a large solution).

After 2 days, while not really installing anything more it increased to 12 mins. We suspect this is caused by an update to VS, IE or SQL server management. In the meantime there were only Microsoft Updates installed.

The opening process went up to nearly 20 minutes, other developers are experiencing times >1hour.

I tried a lot of options (disabling intellisense, deleting .suo and so on) today I just tried it again after a few hours of searching without really changing anything, it only took 2 mins again.. Tried it a few times, always <2min. Locked my pc, went to lunch, came back, time >8 mins again...

I analyzed VS behaviour with the built-in log (it has a gap between to functions)

<entry>
<record>75</record>
<time>2014/03/24 08:20:14.743</time>
<type>Information</type>
<source>Microsoft Visual Studio</source>
<description>End package load [Windows Forms Designer Resources Package]</description>
<guid>{7B5D447B-0B12-41EA-A84E-C822034422D4}</guid>
<record>76</record>
<time>2014/03/24 08:35:19.585</time>
<type>Information</type>
<source>Microsoft Visual Studio</source>
<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>
<guid>{C9DD4A57-47FB-11D2-83E7-00C04F9902C1}</guid>
</entry>

In ProcMon I can see a lot of File Read/Query/Close going on, each file at least 10 times

but in the procmon log of the really fast solution opening there arent really less operations (~88% of the slow run) while the displayed time in the fast run was like ~10% of the slow run..

Any suggestions what i could try to get that always fast?
Post #1554355
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse