Which network library performs best?

[pdalberth]

Given that there is a choice between using TCP/IP or named pipes to connect to SQL Server, which is the better choice in terms of performance?

When using TCP/IP, does using a server name (which then must resolve through DNS) instead of an IP address degrade performance noticeably?

Thanks in advance.

 

[foxdev]

In my experience connecting internally (LAN), TCP/IP worked much faster than Named Pipes...but that may have been a situation peculiar to my network.

When using TCP/IP, does using a server name (which then must resolve through DNS)

If you specify an IP address as the server name (which I often do, since I connect to external servers), then there shouldn't be a name translation effect. Even so, on an internal network, I can't imagine it would degrade performance compared to Named Pipes (which still must resolve the computer name).
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org