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
No comments:
Post a Comment