Re: Local named pipes better than TCP/IP?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rand Boyd [MSFT] (rboyd_at_onlinemicrosoft.com)
Date: 11/18/04 

Date: Thu, 18 Nov 2004 22:03:56 GMT

With SQL Server 2000 the default for local connections (connections made on
the server itself) is shared memory. Steve is correct that named pipes is
for the most part a legacy connection method. I would just use the default
of shared memory for local connections and TCP/IP for remote connections.

Rand
This posting is provided "as is" with no warranties and confers no rights.

Relevant Pages

  • Re: Problems with "Local connections only"
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... We have realized that if we change "Local connections only" for "Local ...
    (microsoft.public.sqlserver.connect)
  • Re: TCP Listeners: Preferences?
    ... There are utilities which attach direct to the main shared memory ... segments - ON-Stat being a representative - but that is different from ... the ON-* commands that connect to shared memory can only ... Well we normally have 10 SHM connections configured and when I sent ...
    (comp.databases.informix)
  • Re: TCP Listeners: Preferences?
    ... There are utilities which attach direct to the main shared memory ... segments - ON-Stat being a representative - but that is different from ... connections (as a for instance; or just olipcstr, ... the ON-* commands that connect to shared memory can only ...
    (comp.databases.informix)
  • Re: Requirement to use Management Studio for local instances
    ... Checked Local connections only in SSSAC for a SQL Server 2005 local ... under the default settings SQL Server does not allow remote connections. ... instance of SQL Express that listens on shared memory, ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: Reducing checkpoints
    ... checkpoints to acceptable levels like 3seconds.What others measures can ... 58sec checkpoints at peak periods .. ... Are your users connecting through shared memory or TCP? ... You're configured for 800 shared memory connections, ...
    (comp.databases.informix)