Can someone tell me what the Shared Memory option is used for when one runs
the SQL client network utility. Start->Rin Cliconfg

There's an option for shared memory protocol. I would like a good technical
description of this option. When to use it and when one doesn't need to use
it.

Many Thanks,
Derek Smigelski
derek.smigelski@bestsoftware.com

Shared Memory is only used for connectons to a local server (running on the
same machine as the client application). Because it avoids the network stack
and uses a shared memory buffer it is extremely efficent but in most cases,
it is prefferable to have a dedicated SQL Server with separate application
servers in order to optimise the use of server resources on the servers
rather than having SQL contending with applications. To control access to
the shared memory, the client and server signal event objects to tell each
other when it is safe to access it. For details on Shared Memory see "Client
and Server Net-Libraries" in BOL.

--
HTH

Jasper Smith (SQL Server MVP)

I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

[quoted text, click to view]