SQL Server 2008 memory bottlenecks

I'm interested in a query that I can run against SQL Server 2008 that will indicate memory usage by current processes (and the users executing them). Any help would be greatly appreciated. Thank.


source to share

2 answers

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 sys.dm_exec_query_memory_grants

. I recommend you read Buffer Management as well .



You can try something like this:

FROM sys.dm_exec_requests  
    CROSS APPLY sys.dm_exec_sql_text(sql_handle)


Or you can run:



to view all users and processes

But as Ezi stated, you can simply use the SQL Server Profiler tool and run a trace.



All Articles