I was under the assumption that each connection consumes around 25K of
memory . Is that correct ?
Is this connection memory consumed from the buffer pool or the memtoleave
area ?
According to BOL each connection uses this amount:
12 KB + (3 * Network Packet Size)
It comes from the memory pool in the first 2GB or 3GB depending on the /3GB
switch setting and not the MemToLeave.
Andrew J. Kelly SQL MVP
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:uQZuZWh7FHA.4012@.TK2MSFTNGP14.phx.gbl...
>I was under the assumption that each connection consumes around 25K of
>memory . Is that correct ?
> Is this connection memory consumed from the buffer pool or the memtoleave
> area ?
>
|||Hi,
please read *memory, amount SQL Server uses* in BOL for more and *memory,
architecture : SQL Server Memory Pool * for more on Memory Architecture. if
you wants to read more on SQL SERVER INTERNALS please read *INSIDE SQL SERVER
BY KALEN DELANY *
HTH
Regards
Andy Davis
Active Crypt Team
---SQL Server Encryption
Decryption Software
http://www.activecrypt.com
"Hassan" wrote:
> I was under the assumption that each connection consumes around 25K of
> memory . Is that correct ?
> Is this connection memory consumed from the buffer pool or the memtoleave
> area ?
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment