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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SSIS, SSMS extremely slow to start with...

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

Rate Topic

Display Mode

Topic Options

Author

Message

Welsh Corgi

Posted Thursday, December 27, 2012 8:09 AM

Hall of Fame

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833, Visits: 4,052

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

Welsh Corgi

Posted Thursday, December 27, 2012 1:34 PM

Hall of Fame

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833, Visits: 4,052

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

@SQLFRNDZ

Posted Thursday, December 27, 2012 3:31 PM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, June 14, 2013 4:19 PM
Points: 412, Visits: 872

How about disabling security software like antivirus and test it..?

--SQLFRNDZ

Post #1400749

Welsh Corgi

Posted Thursday, December 27, 2012 5:39 PM

Hall of Fame

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833, Visits: 4,052

@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

Welsh Corgi

Posted Friday, December 28, 2012 6:31 AM

Hall of Fame

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833, Visits: 4,052

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 »

Permissions