Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

User session memory Expand / Collapse
Author
Message
Posted Monday, July 10, 2006 9:43 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, August 4, 2013 11:06 AM
Points: 397, Visits: 548

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

Post #293207
Posted Monday, July 10, 2006 10:28 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:03 PM
Points: 31,276, Visits: 15,728
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #293219
Posted Monday, December 3, 2012 8:38 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 2:41 PM
Points: 45, Visits: 1,179
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?
Post #1391986
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse