Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS, SSMS extremely slow to start with Network Cable pluged in Expand / Collapse
Author
Message
Posted Thursday, December 27, 2012 8:09 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 6:10 AM
Points: 4,179, Visits: 4,260
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/

Post #1400626
Posted Thursday, December 27, 2012 1:34 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 6:10 AM
Points: 4,179, Visits: 4,260
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/

Post #1400737
Posted Thursday, December 27, 2012 3:31 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 12:04 PM
Points: 463, Visits: 1,023
How about disabling security software like antivirus and test it..?


--SQLFRNDZ
Post #1400749
Posted Thursday, December 27, 2012 5:39 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 6:10 AM
Points: 4,179, Visits: 4,260
@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/

Post #1400760
Posted Friday, December 28, 2012 6:31 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 6:10 AM
Points: 4,179, Visits: 4,260
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/

Post #1400889
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse