Monitoring Resource Governor Memory Grants

SELECT session_id AS SPID, 

 ( SELECT login_name 

 FROM sys.dm_exec_sessions 

 WHERE session_id = a.session_id 

 ) AS Login_Name, 

 ( SELECT [HOST_NAME] 

 FROM sys.dm_exec_sessions 

 WHERE session_id = a.session_id 

 ) AS [Host_Name], 

 ( SELECT cpu_time 

 FROM sys.dm_exec_sessions 

 WHERE session_id = a.session_id 

 ) AS cpu_time, 

 ( SELECT reads 

 FROM sys.dm_exec_sessions 

 WHERE session_id = a.session_id 

 ) AS reads, 

 ( SELECT writes 

 FROM sys.dm_exec_sessions 

 WHERE session_id = a.session_id 

 ) AS writes, 

 ( 

 SELECT TOP 1 [text] 

 FROM sys.dm_exec_cached_plans P 

 CROSS APPLY sys.dm_exec_sql_text(a.plan_handle) 

 ) AS SQL_Query, 

 ( SELECT name 

 FROM sys.dm_resource_governor_workload_groups 

 WHERE group_id = a.group_id 

 ) AS Group_Name, 

 request_time,

 CAST(DATEDIFF(mi, request_time, GETDATE()) AS VARCHAR(3)) + ' Minute(s)' AS Run_Time_Minutes, 

 ( requested_memory_kb / 1024 ) AS requested_memory_mb, 

 required_memory_kb, 

 max_used_memory_kb, 

 ( ideal_memory_kb / 1024 ) AS ideal_memory_mb, 

 ( ( ideal_memory_kb - requested_memory_kb ) / 1024 ) AS memory_required_mb 

FROM sys.dm_exec_query_memory_grants a