When I am opening a Business Intelligence Solution it takes up to 6 minutes
until the system is ready to work.

The first 4 minutes I see Visual Studio with the grey background. In the
remaining time the packages appear but don't accept any input. Meanwhile
Visual Studio is reporting that it is busy and is waiting for an internal
operation to complete.

Any idea how to speed up this process?

Stefan Bublitz

does your cube metadata is big?
My metadata takes 10Mb and required few minutes to be opened.

"SBublitz" <SBublitz@discussions.microsoft.com> wrote in message
news:095B0A32-78DE-418B-854B-243798CAF2C0@microsoft.com...
> When I am opening a Business Intelligence Solution it takes up to 6
> minutes
> until the system is ready to work.
>
> The first 4 minutes I see Visual Studio with the grey background. In the
> remaining time the packages appear but don't accept any input. Meanwhile
> Visual Studio is reporting that it is busy and is waiting for an internal
> operation to complete.
>
> Any idea how to speed up this process?
>
> Stefan Bublitz

I browsed the newsgroups in the meantime and I found a hint that I tried out:

I uninstalled the SSIS SP1 and I re-installed SSIS without SP1.

I don't know if this has been the cause of the problem but obviously it
solved it...

(I found entries in the event log regarding DCOM and MsDtsServer).

--
Stefan Bublitz


"Jeje" wrote:

> does your cube metadata is big?
> My metadata takes 10Mb and required few minutes to be opened.
>
> "SBublitz" <SBublitz@discussions.microsoft.com> wrote in message
> news:095B0A32-78DE-418B-854B-243798CAF2C0@microsoft.com...
> > When I am opening a Business Intelligence Solution it takes up to 6
> > minutes
> > until the system is ready to work.
> >
> > The first 4 minutes I see Visual Studio with the grey background. In the
> > remaining time the packages appear but don't accept any input. Meanwhile
> > Visual Studio is reporting that it is busy and is waiting for an internal
> > operation to complete.
> >
> > Any idea how to speed up this process?
> >
> > Stefan Bublitz
>

oh you talk about an SSIS solution not an SSAS one.

Sorry for this mistake.

and what about the SP2?

with SSIS I suffer slow opening only if my solution was closed and if my
some packages are opened. When I reopen the solution, this reopen all these
packages and takes few times because SSIS validate each package.

You can improve this by changing the validate metadata option of your
connection to false (true by default until SP2, but after a package is
created you have to change this your self)

You can also check the "work offline" option before opening your big
solution.


"SBublitz" <SBublitz@discussions.microsoft.com> wrote in message
news:3A16F4D2-5655-43DD-ACD7-1035EFBBA835@microsoft.com...
>I browsed the newsgroups in the meantime and I found a hint that I tried
>out:
>
> I uninstalled the SSIS SP1 and I re-installed SSIS without SP1.
>
> I don't know if this has been the cause of the problem but obviously it
> solved it...
>
> (I found entries in the event log regarding DCOM and MsDtsServer).
>
> --
> Stefan Bublitz
>
>
> "Jeje" wrote:
>
>> does your cube metadata is big?
>> My metadata takes 10Mb and required few minutes to be opened.
>>
>> "SBublitz" <SBublitz@discussions.microsoft.com> wrote in message
>> news:095B0A32-78DE-418B-854B-243798CAF2C0@microsoft.com...
>> > When I am opening a Business Intelligence Solution it takes up to 6
>> > minutes
>> > until the system is ready to work.
>> >
>> > The first 4 minutes I see Visual Studio with the grey background. In
>> > the
>> > remaining time the packages appear but don't accept any input.
>> > Meanwhile
>> > Visual Studio is reporting that it is busy and is waiting for an
>> > internal
>> > operation to complete.
>> >
>> > Any idea how to speed up this process?
>> >
>> > Stefan Bublitz
>>