ADO.NET SQL Connection Slow

Question

ADO.NET SQL Connection Slow

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

ngross Valued Member Points: 53 More actions · Answer 1

I guess misery loves company so...

Our situation is similar allthough we have figured out it appears to be access to our new SQL box itself. We take our new windows 2003 64 bit web server and point it at our Windows 2003 32 bit SQL environment and everything runs fine. Change the connection to the 2008 Enterprise edition 64 bit with SQL 2005 Server 64 bit and the query time increases by 20 seconds. We did notice an improvement by disabling TOE on the network card, but that improves by around 15 seconds, but results are sporadic at best. Still working with DELL\Equallogic on this issue.

James Cook SSC Veteran Points: 295 More actions · Answer 2

We did find the problem eventually. Windows was trying to do some kind of auto resize on the tcp packets. Turning the auto tune feature off fixed it for us. See this link for how to do it.