Post reply

User session memory

  • 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

  • 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.

  • 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?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply