Hi,

See if this one helps :

select

[text], request_time, grant_time, query_cost, timeout_sec, wait_order, wait_time_ms, group_id,

requested_memory_kb, granted_memory_kb, required_memory_kb, used_memory_kb, max_used_memory_kb, ideal_memory_kb,

query_plan,

*

from sys.dm_exec_query_memory_grants qmg

outer apply sys.dm_exec_sql_text(sql_handle) a

outer apply sys.dm_exec_query_plan(plan_handle) b

Cheers,

Robert