0

When I open SSMS and connect to a database on a corporate LAN it takes 15 minutes for the first connection. Additional connections with SSMS take less than 1 second. After connecting queries execute quickly. I have tried connecting to several servers that are running SQL 2008 and SQL 2012 and SQL 2016, I have use my windows account and SQL logins. I am doing maintenance work on a Winforms application and experience the same delay while running the application in Visual Studio. When I debug and step through the code the delay happens when I hit the Using statement, not the connection.open() that comes after and on the first time data is requested from the database only. Additional requests happen quickly.

Using cn As New SqlClient.SqlConnection(SQL_CONN_STRING), cmd As New SqlClient.SqlCommand(strSQL)
        cn.Open()

The application is deployed out to a network share and users run it from a shortcut on their desktop. It still works for all the users but not for me when I hit the shortcut from my desktop. If I remote to a server then hit the shortcut it works without delay. This application ran fine until last Wednesday. One change I made that day was to install VMware Horizon. Another change was to add a WebEx client. I have since removed both, that did not help. I like a good mystery but this one has me stumped. Any suggestion would be appreciated.

migrated from dba.stackexchange.com Dec 13 '16 at 15:57

This question came from our site for database professionals who wish to improve their database skills and learn from others in the community.

  • Sounds like a network issue. Can you install Management Studio locally? – Arthur D Dec 12 '16 at 21:28
  • Try adding the server you are connecting to into your hostfile, this will make sure it is not an DNS issue – Stijn Wynants Dec 13 '16 at 9:43
  • I have Management Studio installed locally. I only get this delay locally. From another server on the network all is good. Other local users also have no delay. – chuckb35 Dec 13 '16 at 13:24
  • I tried adding the hosts file entry. It did not help. DNS seems to resolve quickly such as when I do a ping. – chuckb35 Dec 13 '16 at 13:25
0

This was caused by the VMWare client install. The procedure here resolved the issue for me: VMWare support site

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.