Intermittent timeout when connecting to Sql Server, what do I look for?

Posted by Will on Server Fault See other posts from Server Fault or by Will
Published on 2010-06-01T19:06:10Z Indexed on 2010/06/01 19:14 UTC
Read the original article Hit count: 221

Sql Server 2008 Standard 64bit on Windows Server 2008 R2 virtual machine hosted on a Hyper-V server.

I'm getting intermittent timeouts when connecting to the server. This happens for both windows and Sql Authentication. May timeout every 2 out of 5 tries in different applications.

When the connection times out, I can see (in Profiler) that no connection was made. Firewall is holey, server port is static (good ol' 1433). If I ping /t the server I get a steady connection that wavers between 1 and 2 ms.

Any ideas what else to try would be appreciated, thanks.

© Server Fault or respective owner

Related posts about sql-server-2008

Related posts about windows-server-2008-r2