I had a similar problem awhile ago - it drove me crazy.
If you already applied SP1, be aware that there is a post-SP1 hotfix for
SSIS - it could solve things...
But what finally solved my problem was this:
in Internet Explorer, go to Tools --> Options --> Advanced
UNcheck the tickbox "Check for publisher's certificate revocation"
That's it - suddenly BIDS reacted 5x faster.
Apparently, BIDS tries to go out to the internet to check something; I was
on an environment with a proxy-server which required credentials all of the
time (when I opened IE and try to go to google, it would ask for username/pwd
to pass the proxy); I'm guessing BIDS tried to go on the internet, without
success, which delayed the whole "experience".
Good luck,
Nico Verheire
[quoted text, click to view] "Lutz Klein" wrote:
> Hello,
>
> i'm using ssis on a machine with 2,8 Ghz, 4 GB RAM and more than 10GB
> storage capacity left on all disks.
> When I do a single click, for example opening a dataflow task or even click
> on it's border to change the label, VS 2005 reacts with a delay of two or
> three seconds. The whole GUI seems to work slow. Sometimes I can watch the
> frames come up one after another. To start a debug-Session or even load a
> packet needs a minute.
> I asked other users in the german forum and they confirmed to get faster
> reactions from their systems. But nobody has a clue, what may cause my system
> to be so slow.
> The SQL-Server itself reacts fast and the OS (Window Server 2003) also. I
> already increased the process priority and turned the otimization of
> background-processes to foreground - no effect. There are no further unusual
> background processes or applications running.
> Do you have any ideas, what the problem might be?
>
> Thanks in advance!
> Lutz Klein
>
> --
Hi,
I overcame a similar problem, concerning startup-time of SSIS packages.
With your workaround I could perfectly solve this issue!
Thanks, Monte
[quoted text, click to view] "Nico Verheire" wrote:
> I had a similar problem awhile ago - it drove me crazy.
>
> If you already applied SP1, be aware that there is a post-SP1 hotfix for
> SSIS - it could solve things...
>
> But what finally solved my problem was this:
> in Internet Explorer, go to Tools --> Options --> Advanced
>
> UNcheck the tickbox "Check for publisher's certificate revocation"
>
> That's it - suddenly BIDS reacted 5x faster.
>
> Apparently, BIDS tries to go out to the internet to check something; I was
> on an environment with a proxy-server which required credentials all of the
> time (when I opened IE and try to go to google, it would ask for username/pwd
> to pass the proxy); I'm guessing BIDS tried to go on the internet, without
> success, which delayed the whole "experience".
>
> Good luck,
> Nico Verheire
>
> "Lutz Klein" wrote:
>
> > Hello,
> >
> > i'm using ssis on a machine with 2,8 Ghz, 4 GB RAM and more than 10GB
> > storage capacity left on all disks.
> > When I do a single click, for example opening a dataflow task or even click
> > on it's border to change the label, VS 2005 reacts with a delay of two or
> > three seconds. The whole GUI seems to work slow. Sometimes I can watch the
> > frames come up one after another. To start a debug-Session or even load a
> > packet needs a minute.
> > I asked other users in the german forum and they confirmed to get faster
> > reactions from their systems. But nobody has a clue, what may cause my system
> > to be so slow.
> > The SQL-Server itself reacts fast and the OS (Window Server 2003) also. I
> > already increased the process priority and turned the otimization of
> > background-processes to foreground - no effect. There are no further unusual
> > background processes or applications running.
> > Do you have any ideas, what the problem might be?
> >
> > Thanks in advance!
> > Lutz Klein
> >
> > --
Don't see what you're looking for? Try a search.