X64 Win7（win2008）连接SqlServer2005慢的解决办法

问题描述：
数据库版本：SQL SERVER 2005
数据库安装环境： Win 2003 X64

客户端环境：Win 2008 x64
连接工具：ODBC或ado.net
测试连接时间：4-6秒

客户端环境：Win xp x32
连接工具：ODBC或ado.net
测试连接时间：<1秒

下面是munnakumar.singh的分析和解决办法，很有效！
munnakumar.singh Posted Monday, February 13, 2012 3:00 AM

Root Cause
-------------------------------------------------------------------
The issue which we were seeing on Win7 VDIs could be due to the Network hardware device connected with the machine. If TCP/IP scaling is not supported by the network device then the performance will be slow.

Solution
-------------------------------------------------------------------
Disable auto tuning level of the TCP. Please follow below steps:
1) Open command Prompt with admin right (Run as Admin)
2) Type “netsh interface tcp set global autotuninglevel=disabled”
3) After running above command restart the machine.

For other information on this command, visit link “http://support.microsoft.com/kb/935400”