Groups | Blog | Home
all groups > sql server dts > august 2006 >

sql server dts : ssis - Visual Studio 2005 running very slow


Lutz Klein
8/28/2006 4:10:02 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

--
Nico Verheire
8/31/2006 8:14:02 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

[quoted text, click to view]
Monte
10/23/2006 2:15:02 AM
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]
AddThis Social Bookmark Button