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有不同的视图.