468,483 Members | 2,708 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,483 developers. It's quick & easy.

SQL 2005 on Windows Server 2008 - Slow Connection Time

Hey Folks,

Experiencing strange problem with SQL 2005 running on Windows Server
2008. When trying to connect via named pipes or tcp, it takes 25-45
seconds for the connection to be established. Looked at some posts
about IPv6 possibly causing the problem when in stacked ipv4/ipv6
environment, but not seeing any results after un-binding ipv6
protocol.

After running some tests, interaction with the DB Server is slow even
after connection. Queries against the same databases take longer on
this server versus an existing server.

Any ideas out there?

Thanks...
Jun 27 '08 #1
1 6121
GatorDBA (ga*********@gmail.com) writes:
Experiencing strange problem with SQL 2005 running on Windows Server
2008. When trying to connect via named pipes or tcp, it takes 25-45
seconds for the connection to be established. Looked at some posts
about IPv6 possibly causing the problem when in stacked ipv4/ipv6
environment, but not seeing any results after un-binding ipv6
protocol.
Do you connect with Windows authentication or SQL Server authentication?
If the former, could you try the latter and see if it makes any
difference?
After running some tests, interaction with the DB Server is slow even
after connection. Queries against the same databases take longer on
this server versus an existing server.

Any ideas out there?
Does this happen also when you run queries locally and you are connected
through shared memory?
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jun 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Rami Saarinen | last post: by
3 posts views Thread by Lee T. Hawkins | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by kmladenovski | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.