Re: SQL Application Performance much better with Named Pipes than TCP\

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 01/26/05 

Date: Wed, 26 Jan 2005 01:49:16 GMT

You can also use Netdiag.exe to troubleshoot network related problems with
DNS or DC enumeration.

812809 Windows 2000 SP4 Support Tools
http://support.microsoft.com/?id=812809

Also, get you network staff to make a quick trace running the same query
against the server with pipes vs tcp and let them review the traces.

Authentication can also play a role in delays as well. Trusted connections
over TCP may be using Kerberos which could be impacted by DNS problems, vs
Named Pipes connections use NTLM Authentication only.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.