In a fast LAN environment, TCP/IP and Named Pipes client are comparable in
terms of performance. However, the performance difference between them
becomes apparent with slower networks, such as across WAN or dial-up
networks. It is recommended that you use TCP/IP. For more information,
please refer to Microsoft SQL Server with the keyword 'Named Pipes vs.
TCP/IP Sockets' as the search topic.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.