SQL Server 2008 memory bottlenecks
report memory usage by current memory processes
This is too general and cannot be answered. Almost all memory in SQL is shared between "processes" (queries) and cannot be categorized as separate. The only significant memory consumption that can be explicitly related to the request is the memory grant that maps to
. I recommend you read Buffer Management as well .
source to share