How to find out if you have sufficient memory on sql server

ara3n

I saw this blog that had the query.

http://blog.sqlauthority.com/2009/10/09 ... o-execute/

SELECT TEXT, query_plan, requested_memory_kb,
granted_memory_kb,used_memory_kb, wait_order
FROM sys.dm_exec_query_memory_grants MG
CROSS APPLY sys.dm_exec_sql_text(sql_handle)
CROSS APPLY sys.dm_exec_query_plan(MG.plan_handle)