User session memory

• sqlstar2011

  SSCertifiable

  Points: 6000

  More actions

  July 10, 2006 at 9:43 am

  #366635

  Is there a way to find out how much memory a user session is taking? I have an application that is creating about 1000 sessions into the database. I would like to find out if there is way to figure out how much memory all of these sessions taking?

  Anyone any idea?

   

  thanks

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737519

  More actions

  July 10, 2006 at 10:28 am

  #648287

  Each connection uses a certain amount of memory, which is what they use. They do not hold memory beyond the duration of their particular batch.

  DBCC MemoryStatus (http://support.microsoft.com/?id=271624) gives info on overall memory.

• shanghaigirl-1125377

  Ten Centuries

  Points: 1231

  More actions

  December 3, 2012 at 8:38 am

  #1564912

  Steve Jones - SSC Editor (7/10/2006)

  ---

  They do not hold memory beyond the duration of their particular batch.

  Do you mean they are not holding memories if sessions are sleeping?