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 ?
>
>
Showing posts with label buffer. Show all posts
Showing posts with label buffer. Show all posts
Tuesday, March 20, 2012
connection memory
How much memory does each connection to SQL Server hold ? Is that stored in
the buffer pool area ?Connection memory is stored both in the buffer pool and the mem-to-leave
area. You can get an idea of how much memory each connection is using by
querying the sysprocesses table (see the memusage column), but keep in mind
that some of that memory is shared so it's impossible (as far as I know) to
get an exact number. You can also get some helpful information about
connection memory from DBCC MEMORYSTATUS.
Adam Machanic
SQL Server MVP - http://sqlblog.com
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Hassan" <hassan@.hotmail.com> wrote in message
news:uingOA98HHA.4612@.TK2MSFTNGP03.phx.gbl...
> How much memory does each connection to SQL Server hold ? Is that stored
> in the buffer pool area ?
>
>|||It costs 28KB to only establish a connection to SQL Server 2005.
--
Ekrem Önsoy
MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT
"Hassan" <hassan@.hotmail.com> wrote in message
news:uingOA98HHA.4612@.TK2MSFTNGP03.phx.gbl...
> How much memory does each connection to SQL Server hold ? Is that stored
> in the buffer pool area ?
>
>sqlsql
the buffer pool area ?Connection memory is stored both in the buffer pool and the mem-to-leave
area. You can get an idea of how much memory each connection is using by
querying the sysprocesses table (see the memusage column), but keep in mind
that some of that memory is shared so it's impossible (as far as I know) to
get an exact number. You can also get some helpful information about
connection memory from DBCC MEMORYSTATUS.
Adam Machanic
SQL Server MVP - http://sqlblog.com
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Hassan" <hassan@.hotmail.com> wrote in message
news:uingOA98HHA.4612@.TK2MSFTNGP03.phx.gbl...
> How much memory does each connection to SQL Server hold ? Is that stored
> in the buffer pool area ?
>
>|||It costs 28KB to only establish a connection to SQL Server 2005.
--
Ekrem Önsoy
MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT
"Hassan" <hassan@.hotmail.com> wrote in message
news:uingOA98HHA.4612@.TK2MSFTNGP03.phx.gbl...
> How much memory does each connection to SQL Server hold ? Is that stored
> in the buffer pool area ?
>
>sqlsql
connection memory
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 ?
>
>
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 ?
>
>
connection memory
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. i
f
you wants to read more on SQL SERVER INTERNALS please read *INSIDE SQL SERVE
R
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 ?
>
>
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. i
f
you wants to read more on SQL SERVER INTERNALS please read *INSIDE SQL SERVE
R
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 ?
>
>
Friday, February 24, 2012
Connection contexts and Lock Resources..
Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend to
the AWE if need be as well or is it just limited to non AWE memory.
Thank you..Hassan
Yes , locks 'mean' memory. Can you elaborate about AWE question?
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
> to the AWE if need be as well or is it just limited to non AWE memory.
> Thank you..
>|||The ONLY thing that can live in memory above 2GB (or 3GB if /3GB is set) on
a 32 bit machine is data that is cached in the data buffer pool.
Andrew J. Kelly SQL MVP
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
> to the AWE if need be as well or is it just limited to non AWE memory.
> Thank you..
>|||Thanks Andrew
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eMcjfBoMHHA.992@.TK2MSFTNGP06.phx.gbl...
> The ONLY thing that can live in memory above 2GB (or 3GB if /3GB is set)
> on a 32 bit machine is data that is cached in the data buffer pool.
> --
> Andrew J. Kelly SQL MVP
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
>
the AWE if need be as well or is it just limited to non AWE memory.
Thank you..Hassan
Yes , locks 'mean' memory. Can you elaborate about AWE question?
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
> to the AWE if need be as well or is it just limited to non AWE memory.
> Thank you..
>|||The ONLY thing that can live in memory above 2GB (or 3GB if /3GB is set) on
a 32 bit machine is data that is cached in the data buffer pool.
Andrew J. Kelly SQL MVP
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
> to the AWE if need be as well or is it just limited to non AWE memory.
> Thank you..
>|||Thanks Andrew
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eMcjfBoMHHA.992@.TK2MSFTNGP06.phx.gbl...
> The ONLY thing that can live in memory above 2GB (or 3GB if /3GB is set)
> on a 32 bit machine is data that is cached in the data buffer pool.
> --
> Andrew J. Kelly SQL MVP
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
>
Connection contexts and Lock Resources..
Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend to
the AWE if need be as well or is it just limited to non AWE memory.
Thank you..
Hassan
Yes , locks 'mean' memory. Can you elaborate about AWE question?
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
> to the AWE if need be as well or is it just limited to non AWE memory.
> Thank you..
>
|||The ONLY thing that can live in memory above 2GB (or 3GB if /3GB is set) on
a 32 bit machine is data that is cached in the data buffer pool.
Andrew J. Kelly SQL MVP
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
> to the AWE if need be as well or is it just limited to non AWE memory.
> Thank you..
>
|||Thanks Andrew
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eMcjfBoMHHA.992@.TK2MSFTNGP06.phx.gbl...
> The ONLY thing that can live in memory above 2GB (or 3GB if /3GB is set)
> on a 32 bit machine is data that is cached in the data buffer pool.
> --
> Andrew J. Kelly SQL MVP
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
>
the AWE if need be as well or is it just limited to non AWE memory.
Thank you..
Hassan
Yes , locks 'mean' memory. Can you elaborate about AWE question?
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
> to the AWE if need be as well or is it just limited to non AWE memory.
> Thank you..
>
|||The ONLY thing that can live in memory above 2GB (or 3GB if /3GB is set) on
a 32 bit machine is data that is cached in the data buffer pool.
Andrew J. Kelly SQL MVP
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
> to the AWE if need be as well or is it just limited to non AWE memory.
> Thank you..
>
|||Thanks Andrew
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eMcjfBoMHHA.992@.TK2MSFTNGP06.phx.gbl...
> The ONLY thing that can live in memory above 2GB (or 3GB if /3GB is set)
> on a 32 bit machine is data that is cached in the data buffer pool.
> --
> Andrew J. Kelly SQL MVP
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
>
Connection contexts and Lock Resources..
Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend to
the AWE if need be as well or is it just limited to non AWE memory.
Thank you..Hassan
Yes , locks 'mean' memory. Can you elaborate about AWE question?
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
> to the AWE if need be as well or is it just limited to non AWE memory.
> Thank you..
>|||The ONLY thing that can live in memory above 2GB (or 3GB if /3GB is set) on
a 32 bit machine is data that is cached in the data buffer pool.
--
Andrew J. Kelly SQL MVP
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
> to the AWE if need be as well or is it just limited to non AWE memory.
> Thank you..
>|||Thanks Andrew
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eMcjfBoMHHA.992@.TK2MSFTNGP06.phx.gbl...
> The ONLY thing that can live in memory above 2GB (or 3GB if /3GB is set)
> on a 32 bit machine is data that is cached in the data buffer pool.
> --
> Andrew J. Kelly SQL MVP
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
>> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
>> to the AWE if need be as well or is it just limited to non AWE memory.
>> Thank you..
>
the AWE if need be as well or is it just limited to non AWE memory.
Thank you..Hassan
Yes , locks 'mean' memory. Can you elaborate about AWE question?
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
> to the AWE if need be as well or is it just limited to non AWE memory.
> Thank you..
>|||The ONLY thing that can live in memory above 2GB (or 3GB if /3GB is set) on
a 32 bit machine is data that is cached in the data buffer pool.
--
Andrew J. Kelly SQL MVP
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
> to the AWE if need be as well or is it just limited to non AWE memory.
> Thank you..
>|||Thanks Andrew
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eMcjfBoMHHA.992@.TK2MSFTNGP06.phx.gbl...
> The ONLY thing that can live in memory above 2GB (or 3GB if /3GB is set)
> on a 32 bit machine is data that is cached in the data buffer pool.
> --
> Andrew J. Kelly SQL MVP
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
>> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
>> to the AWE if need be as well or is it just limited to non AWE memory.
>> Thank you..
>
Subscribe to:
Posts (Atom)