dbTalk Databases Forums  

ssis - Visual Studio 2005 running very slow

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss ssis - Visual Studio 2005 running very slow in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Lutz Klein
 
Posts: n/a

Default ssis - Visual Studio 2005 running very slow - 08-28-2006 , 06:10 AM






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

--
---

Reply With Quote
  #2  
Old   
Nico Verheire
 
Posts: n/a

Default RE: ssis - Visual Studio 2005 running very slow - 08-31-2006 , 10:14 AM






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:

Quote:
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

--
---

Reply With Quote
  #3  
Old   
Monte
 
Posts: n/a

Default RE: ssis - Visual Studio 2005 running very slow - 10-23-2006 , 04:15 AM



Hi,

I overcame a similar problem, concerning startup-time of SSIS packages.
With your workaround I could perfectly solve this issue!

Thanks, Monte


"Nico Verheire" wrote:

Quote:
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

--
---

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.