Session memory usage

[Fredrik Bertilsson]

Hi,
does someone know how much memory a user session takes on a SQLServer
database server? How many concurrent user sessions can a normal server
(4 GB primary memory) handle, before connection pooling is needed?

/Fredrik

[Simon Hayes]

fr****************@passagen.se (Fredrik Bertilsson) wrote in message news:<31**************************@posting.google. com>...

Hi,
does someone know how much memory a user session takes on a SQLServer
database server? How many concurrent user sessions can a normal server
(4 GB primary memory) handle, before connection pooling is needed?

/Fredrik

24KB by default - see "Memory Used by SQL Server Objects
Specifications" in Books Online. But this isn't usually an issue -
what's more important is the cache memory required to support the
queries the user is executing. As for concurrent users, if an
application is well designed to avoid locking then it should scale
well, but a badly designed one could have problems with just a handful
of users.

Simon

[Greg D. Moore \(Strider\)]

"Simon Hayes" <sq*@hayes.ch> wrote in message
news:60**************************@posting.google.c om...

fr****************@passagen.se (Fredrik Bertilsson) wrote in message news:<31**************************@posting.google. com>...

Hi,
does someone know how much memory a user session takes on a SQLServer
database server? How many concurrent user sessions can a normal server
(4 GB primary memory) handle, before connection pooling is needed?

/Fredrik

24KB by default - see "Memory Used by SQL Server Objects
Specifications" in Books Online. But this isn't usually an issue -
what's more important is the cache memory required to support the
queries the user is executing. As for concurrent users, if an
application is well designed to avoid locking then it should scale
well, but a badly designed one could have problems with just a handful
of users.

Also, it's often the time to build up and tear down the connection that's
time consuming, hence another reason (and probably more important) to use
connection pooling.

Simon