SQL Server 2008 memory bottlenecks

Question

I am interested in query that I can run against SQL Server 2008 that would tell the memory usage of the current processes (and users running them) executing. Any help would be appreciated. Thank you.

Answer 1

tell the memory usage of the current processes

This is too generic and cannot be answered. Almost all the memory in SQL is shared between 'processes' (queries) and cannot be attributed to an individual one. The only significant memory consumption that can be clearly attributed to a query is the memory grant and that is exposed in sys.dm_exec_query_memory_grants. I recommend you read also about Buffer Management.