litu deb
SSC Eights!
Points: 818
More actions
February 25, 2010 at 12:03 am
#211735
can you tell me what is the command to know which spid taking max memory?
Jack Corbett
SSC Guru
Points: 184394
February 25, 2010 at 7:25 am
#1124969
I'm not sure that this is perfect, but you can look at sys.dm_exec_sessions which has a memory_usage column that shows the # of 8KB pages used by the session.
Jack CorbettConsultant - Straight Path SolutionsCheck out these links on how to get faster and more accurate answers:Forum Etiquette: How to post data/code on a forum to get the best help Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply