sql-server – 最快的SQL Server协议？

相关：哪些协议可用于远程与本地,并且会影响最快协议的选择？

解决方法

Note that the VIA protocol is deprecated
by Microsoft,and will be removed in a
future version of Microsoft SQL Server.
It is however supported in SQL Server 2008,
SQL Server 2008 R2 and SQL Server 2012.

共享内存接下来是性能,但它只能在客户端和实际共享内存的服务器之间工作,因此仅在本地使用.

对于普通硬件上的远程连接,TCP是要走的路.在正常操作下,它具有与命名管道相同的性能.在慢或繁忙的网络中,它的鲁棒性和速度优于NP,事实documented in MSDN：

For named pipes,network
communications are typically more
interactive. A peer does not send data
until another peer asks for it using a
read command. A network read typically
involves a series of peek named pipes
messages before it starts to read the
data. These can be very costly in a
slow network and cause excessive
network traffic,which in turn affects
other network clients.

命名管道也可能导致客户端连接超时：

TCP/IP Sockets also support a backlog
queue. This can provide a limited
smoothing effect compared to named
pipes that could lead to pipe-busy
errors when you are trying to connect
to SQL Server.

不幸的是,正常的客户端配置首先尝试NP,这可能会导致连接问题(由于上述原因),其中在客户端网络配置(或连接字符串,通过tcp：servername)中执行TCP跳过NP连接尝试并直接转到TCP在负载下获得更好的体验.

现在确实的是,上面引用的相同链接对NP进行了简单的配置,最有可能指的是不需要在防火墙中打开SQL TCP端口,但是在那里我和BOL有不同的视图.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!