Find Memory Usage of Executing Procedures

Posted by Derek Dieter
on June 17 2009

To get the query memory usage of currently executing queries run the following:

SELECT
	TEXT
	,query_plan
	,requested_memory_kb
	,granted_memory_kb
	,used_memory_kb
FROM sys.dm_exec_query_memory_grants emg
CROSS APPLY sys.dm_exec_sql_text(sql_handle)
CROSS APPLY sys.dm_exec_query_plan(emg.plan_handle)
ORDER BY emg.requested_memory_kb DESC

Related Posts:
»Find Queries Using Most CPU
»Find Queries Using Most Memory (IO)
»Find Queries Taking Most CPU (Processor)
»Find Queries Performing Most Writes (Inserts)
»Find All Queries Run Against a Table
»Find Procedures using Most Memory DMV
»Find Most Executed Queries
»Find Most Blocked Queries
»Find Long Running Queries
»Find Most Executed Stored Procedures

Popular search terms:

Filed under DMV Queries Tagged DMV, memory

Comment (RSS) | Permalink

One Comment

praful says:

September 6, 2011 at 1:51 am

my stored proecedure run 4 min off peak time and 30 mins in peak time, i am not able to find the cause for 30 mins duration.Please tell me the various ways to find the bottleneck cause solution.
we has transaction replication setup on the same server.

Reply to this comment

post a comment OR Post Your Question on our ASK! Community!