Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Wednesday, June 29, 2016 1:59 PM
Points: 399, Visits: 592

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 @ 7:15 AM
Points: 34,087, Visits: 18,222
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: Wednesday, August 10, 2016 2:46 PM
Points: 45, Visits: 1,186
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