Exit it in sqlserver notion of shared connection or dedicaced connection like there is exist in oracle ?
Exit it a part of memory (like PGA in oracle) who exist just for the connections ?
Else what are constitued the memory in sqlserver ?
The concepts are completely different, and they are implemented in different ways, but the answer to both of the questions you've posed are probably yes. If you can come up with a more specific question, I'm sure that someone here can answer it in a more specific way.