Clever Geek Handbook

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.

+3


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 .

+4


source


You can try something like this:

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

Or you can run:



sp_who

to view all users and processes

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

+1


source






More articles:


All Articles