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

ara3nara3n Member Posts: 9,250
edited 2009-10-09 in SQL Tips & Tricks
I saw this blog that had the query. ... 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)
Ahmed Rashed Amini
Independent Consultant/Developer

Sign In or Register to comment.