SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS, SSMS extremely slow to start with Network Cable pluged in


SSIS, SSMS extremely slow to start with Network Cable pluged in

Author
Message
Welsh Corgi
Welsh Corgi
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10070 Visits: 4893
Starting last Friday developers starting having trouble with in some cases SSIS and in others SSMS.

For instance one developer would start BIDS and a devenv.exe process would start but it would not load the application for 30 minutes to an hour.

I had them unplug the network cable and BIDS launched immediately.

Another developer can launch BIDS but not SSIS. A ssms.exe process starts for every attempt but the SSMS Application does not launch.

I had the developer disconnect the network cable and SSMS started immediately.

I have the same problem with BIDS(SSIS) on a Windows Server.

If I run an SSIS Package I get unusual errors, SSIS can't connect to Server even after I have tested the connection, etc.

A Manager can open SSIS but it just freezes.

Some developers are not affected at all.

I have check for something common that is installed on the PC's/Server but I could not find anything.

My thought would be to disable the service(s) but that is not applicable in this situation.

I suspect some sort of network tool that is interfering with SQL Server.

I have checked the Event Viewer but there are not any entries.

Any help would be greatly appreciated.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Welsh Corgi
Welsh Corgi
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10070 Visits: 4893
I going to try and reinstall BIDS on this one PC?

I had someone connect to another machine and they are to start BIDS and validate the SSIS Package rather quickly. Wierd.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
@SQLFRNDZ
@SQLFRNDZ
SSC Eights!
SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)

Group: General Forum Members
Points: 887 Visits: 1217
How about disabling security software like antivirus and test it..?


--SQLFRNDZ

Welsh Corgi
Welsh Corgi
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10070 Visits: 4893
@SQLFRNDZ (12/27/2012)
How about disabling security software like antivirus and test it..?


Yes that is what I initially thought. I should have mentioned it.

I reinstalled BIDs on one of the PC's that was having this problem and it works.

On another Machine (Server) I had someone login and they were able to launch BIDS and the package validated relatively fast. That sound like it has to do with a BIDS user file that is corrupt.

I tried staring BIDS from the command line including Safe Mode but no luck so far.


Thanks.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Welsh Corgi
Welsh Corgi
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10070 Visits: 4893
On the machine that I reinstalled BIDS and it launched using my login it did not work for the Developer who uses that machine.

Similar situation on another machine. I log in it does not launch and another person logs i n and it works for him.

I suspect that there are some BIDS files specific to a user that are corrupt and is causing this issue.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search