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

ara3nara3n Member Posts: 9,242
edited 2009-10-09 in SQL Tips & Tricks
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)
Ahmed Rashed Amini
Independent Consultant/Developer


blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.