when talking about the network library , what is shared memory 1

[Rousseau10]

when talking about the network library , what is shared memory. I see this term, but am not exactly who is sharing the memory and why. SQL server, the client?

 

[Rousseau10]

thanks so much!

Newbee - Adam

 

[jitter]

I don't know a lot about it under the hood but know the following:

From:
BOL - Shared Memory

The shared memory Net-Library is used only for local connections, and does not use a network. The shared memory Net-Library is always active; it cannot be enabled or disabled.

From:

http://doc.ddart.net/mssql/sql2000/html/adminsql/ad_1_client_0v5f.htm

If the connection is local on a computer (client and server on the same computer), an instance of SQL Server listens on the server Shared Memory Net-Library.

I don't know if this is what you are looking for but thought I would pass on.

jitter

Instead of shooting where I was, you should have shot where I was going to be. - Lrrr (Planet Nintendio64)