dm_exec_query_memory_grants

SELECT * FROM Sys.dm_exec_query_memory_grants

Returns information about the queries that have acquired a memory grant or that still require a memory grant to execute.

http://msdn.microsoft.com/en-us/library/ms365393.aspx